Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Can I delete tabs at one go ? | Excel Discussion (Misc queries) | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
Excel 2002 : Can I speed fill tabs ? | Excel Discussion (Misc queries) | |||
Can I hide rows in Excel 2002 using a formula in a cell? | Excel Discussion (Misc queries) | |||
How do I Hide Excel 2002 Hyperlink ScreenTip? | Excel Discussion (Misc queries) |