View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default 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