how to hide work sheets in a workbook

one way
format>sheet>hide

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Venkat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> how to hide work sheets in a workbook
>
>
>
>

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: (E-Mail Removed)
=-=-=-=-=-=-=-=-=-=-=-=-
"Don Guillett" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> one way
> format>sheet>hide
>
> --
> Don Guillett
> SalesAid Software
> (E-Mail Removed)
> "Venkat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>
>> how to hide work sheets in a workbook
>>
>>
>>
>>
>
>

"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


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=522208

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.)

Venkat wrote:
>
> 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: (E-Mail Removed)
> =-=-=-=-=-=-=-=-=-=-=-=-
> "Don Guillett" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > one way
> > format>sheet>hide
> >
> > --
> > Don Guillett
> > SalesAid Software
> > (E-Mail Removed)
> > "Venkat" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >>
> >> how to hide work sheets in a workbook
> >>
> >>
> >>
> >>
> >
> >

--

Dave Peterson

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


--
Regards
Venkat SA
"EdMac" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> "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
>
>
> --
> EdMac
> ------------------------------------------------------------------------
> EdMac's Profile:
> http://www.excelforum.com/member.php...o&userid=30736
> View this thread: http://www.excelforum.com/showthread...hreadid=522208
>