Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding tabs in Excel
Hi folks,
Looking to hide a few tabs in Excel. Quite simply, so they don't show up along the bottom of my worksheet. Is there any way of doing this? Thanks :) |
#2
|
|||
|
|||
Quote:
However, they can be unhidden by the user unless you protect the workbook too. Hope that helps. S. |
#3
|
|||
|
|||
Quote:
Thanks! Unfortunately I don't have the option to Hide when I right click on the tabs? |
#4
|
|||
|
|||
Which version of Excel are you using??
|
#6
|
|||
|
|||
In that case, select the tab you wish to hide, then select the "Format" drop down menu, then "Sheet", then "Hide". Et voila! :)
|
#7
|
|||
|
|||
Perfect! That got it. Thanks a lot Spencer :)
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding tabs in Excel
On Thursday, March 15, 2012 2:56:35 PM UTC-5, benallen105 wrote:
Spencer101;1599842 Wrote: In that case, select the tab you wish to hide, then select the "Format" drop down menu, then "Sheet", then "Hide". Et voila! :) Perfect! That got it. Thanks a lot Spencer :) -- benallen105 And IF? you want to prevent user from UN hiding then use a macro with VERYHIDDEN .Then ONLY a macro will unhide. Then protect your macros. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Tabs | Excel Programming | |||
Hiding Tabs | Excel Discussion (Misc queries) | |||
Hiding Tabs | Excel Programming | |||
Hiding Tabs | Excel Programming | |||
Hiding Tabs | Excel Programming |