Excel 2002 : Can I hide the tabs ?
 

Hi,

I have a large worksheet with many tabs

If I do not want the receipient of the file to access to some of the tabs

May I know if there is a way for me to hide those tabs under Excel 2002 ?

If not, what about in Excel 2007 ?

Thanks

Low


--
A36B58K641

Excel 2002 : Can I hide the tabs ?
 

In 2007 right click the sheet tab Hide ...and save the file

If this post helps click Yes
---------------
Jacob Skaria


"Mr. Low" wrote:

Hi,

I have a large worksheet with many tabs

If I do not want the receipient of the file to access to some of the tabs

May I know if there is a way for me to hide those tabs under Excel 2002 ?

If not, what about in Excel 2007 ?

Thanks

Low


--
A36B58K641

Excel 2002 : Can I hide the tabs ?
 

In 2002 select a tab and FormatHide.

NOTE..........users can easily unhide these using FormatUnhide.

Even if you use VBA to make the sheets "veryhidden" a determined user can
still work around that.

My advice..................if you don't want them to see it..........don't
include it when you send to recipient.

Make a workbook with just what recipient needs.

Send that workbook.


Gord Dibben MS Excel MVP


On Wed, 5 Aug 2009 06:37:01 -0700, Mr. Low
wrote:

Hi,

I have a large worksheet with many tabs

If I do not want the receipient of the file to access to some of the tabs

May I know if there is a way for me to hide those tabs under Excel 2002 ?

If not, what about in Excel 2007 ?

Thanks

Low

Excel 2002 : Can I hide the tabs ?
 

Gord Dibben wrote:
In 2002 select a tab and FormatHide.

NOTE..........users can easily unhide these using FormatUnhide.

Even if you use VBA to make the sheets "veryhidden" a determined user can
still work around that.

My advice..................if you don't want them to see it..........don't
include it when you send to recipient.

Make a workbook with just what recipient needs.

Send that workbook.


Gord Dibben MS Excel MVP


On Wed, 5 Aug 2009 06:37:01 -0700, Mr. Low
wrote:

Hi,

I have a large worksheet with many tabs

If I do not want the receipient of the file to access to some of the tabs

May I know if there is a way for me to hide those tabs under Excel 2002 ?

If not, what about in Excel 2007 ?

Thanks

Low

Take Gord's good advice!

Bill