hiding the worksheet
 

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

With the worksheet on screen, click ~Format ~Sheet ~Hide.

hiding the worksheet
 

Click on "Format", "Sheet", "Hide". This will hide the worksheet.

"Narnimar" wrote:

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

Narnimar

Another way... right click on the tab you want to hide and select "Hide"

Mike Rogers

"Narnimar" wrote:

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

Mike

This is not native to Excel before 2007 version and I don't know if possible in
2007.

Do you have a "Hide" command added to the sheet tab right-click menu?


Gord Dibben MS Excel MVP

On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers
wrote:

Narnimar

Another way... right click on the tab you want to hide and select "Hide"

Mike Rogers

"Narnimar" wrote:

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

Gord

So it only takes me six months to get back to you on this comment. 3

As a matter of fact I do have "Hide on my Sheet tab right click menu. Just
went and checked again and it is there. There is not an Unhide tho for that
I have to goto format....etc. I am using 2000 student/teacher edition, I do
have several addins that I have accumulated through the years, maybe it is
from one of them.


Interesting

Mike Rogers
--
The only dumb question is the one you did not ask.


"Gord Dibben" wrote:

Mike

This is not native to Excel before 2007 version and I don't know if possible in
2007.

Do you have a "Hide" command added to the sheet tab right-click menu?


Gord Dibben MS Excel MVP

On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers
wrote:

Narnimar

Another way... right click on the tab you want to hide and select "Hide"

Mike Rogers

"Narnimar" wrote:

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

And my Excel add-in "XL Extras" is one of those that do.
It also provides an "Unhide All" command on the Format |Sheet menu.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Mike Rogers"
<Mike060349@NoxSpamxAOLDOTcom
wrote in message
Gord
So it only takes me six months to get back to you on this comment. 3

As a matter of fact I do have "Hide on my Sheet tab right click menu. Just
went and checked again and it is there. There is not an Unhide tho for that
I have to goto format....etc. I am using 2000 student/teacher edition, I do
have several addins that I have accumulated through the years, maybe it is
from one of them.
Interesting
Mike Rogers
--
The only dumb question is the one you did not ask.


"Gord Dibben" wrote:
Mike

This is not native to Excel before 2007 version and I don't know if possible in
2007.

Do you have a "Hide" command added to the sheet tab right-click menu?


Gord Dibben MS Excel MVP

On Thu, 28 Dec 2006 07:16:01 -0800, Mike Rogers
wrote:

Narnimar

Another way... right click on the tab you want to hide and select "Hide"

Mike Rogers

"Narnimar" wrote:

I need to know how to hide a worksheet within the excel workbook. any body
can help me?

hiding the worksheet
 

Thanks for the feedback Mike.

One of those add-ins must be putting the "Hide" command on the sheet right-click
menu.

To find it, do a search on "Ply" which is the name of the sheet right-click
menu.


Gord

On Tue, 10 Jul 2007 20:38:03 -0700, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

Gord

So it only takes me six months to get back to you on this comment. 3

As a matter of fact I do have "Hide on my Sheet tab right click menu. Just
went and checked again and it is there. There is not an Unhide tho for that
I have to goto format....etc. I am using 2000 student/teacher edition, I do
have several addins that I have accumulated through the years, maybe it is
from one of them.


Interesting

Mike Rogers

hiding the worksheet
 

Gord

I think Jim hit the nail on the head.... I do have his addin employed,
thanks Jim!!!
Now I have to be careful and keep track of what does what and who it is from
<g . Thanks guys!!

Mike Rogers
--
The only dumb question is the one you did not ask.


"Gord Dibben" wrote:

Thanks for the feedback Mike.

One of those add-ins must be putting the "Hide" command on the sheet right-click
menu.

To find it, do a search on "Ply" which is the name of the sheet right-click
menu.


Gord

On Tue, 10 Jul 2007 20:38:03 -0700, Mike Rogers <Mike060349@NoxSpamxAOLDOTcom
wrote:

Gord

So it only takes me six months to get back to you on this comment. 3

As a matter of fact I do have "Hide on my Sheet tab right click menu. Just
went and checked again and it is there. There is not an Unhide tho for that
I have to goto format....etc. I am using 2000 student/teacher edition, I do
have several addins that I have accumulated through the years, maybe it is
from one of them.


Interesting

Mike Rogers