how to hide work sheets in a workbook

V

Venkat

hi thanks for the info. it works
alternatively I was right clicking on the sheet tab > code > properties and
used to make the visible property of the sheet to invisible.
that also works, but not so easy as format > sheet > hide

By the way 1 question, why is hide not available when u right click on the
sheet tab?

--
=-=-=-=-=-=-=-=-=-=-=-=-
Thanks and Regards
Venkat SA

M: 973 - 3978 2493
R: 973 - 17 2345 17
E: [email protected]
=-=-=-=-=-=-=-=-=-=-=-=-
 
E

EdMac

"By the way 1 question, why is hide not available when u right click on
the
sheet tab"


The answer, I think, is obvious - how would you unhide something that
was invisible and which you did not know existed!

Ed
 
D

Dave Peterson

There are lots of things that many people find useful that aren't available
right out of the box.

You could use some code to modify the menu you get when you rightclick on that
worksheet tab--or you could even create a new toolbar that has your favorite
icons--and thare are lots of icons that aren't displayed on the normal toolbars.

tools|customize|toolbars tab|create a new toolbar
then on the Commands tab|built-in menus category. Drag Sheet to that new
toolbar.

Or you can use:
tools|customize (just to see that dialog)
then click on Format|Sheet and ctrl-drag Hide to that new toolbar
You'll get to that feature more quickly.

(If you drag the icon, you move it. Ctrl-drag and you're copying it.)
 
V

Venkat

to ed's answer,
then how do we unhide columns in excel when u have hidden the columns
the same way we should be able to unhide sheets as well
 
Top