Excel 2002 : Can I hide the tabs ?

[Mr. Low]

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

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Gord Dibben]

In 2002 select a tab and Format>Hide.

NOTE..........users can easily unhide these using Format>Unhide.

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

 

[Bill Sharpe]

In 2002 select a tab and Format>Hide.

NOTE..........users can easily unhide these using Format>Unhide.

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

Take Gord's good advice!

Bill