Excel 2002 : Can I hide the tabs ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

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
 
In 2007 right click the sheet tab >Hide ...and save the file

If this post helps click Yes
 
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
 
Gord said:
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
Click to expand...
Take Gord's good advice!

Bill
 
Back
Top