Hiding tabs in Excel

[benallen105]

Hi folks,

Looking to hide a few tabs in Excel. Quite simply, so they don't show u
along the bottom of my worksheet. Is there any way of doing this?

Thanks :

 

[Spencer101]

Hi folks,

Looking to hide a few tabs in Excel. Quite simply, so they don't show u
along the bottom of my worksheet. Is there any way of doing this?

Thanks

Yup. You should be able to right click the tab and select hide.
However, they can be unhidden by the user unless you protect th
workbook too.

Hope that helps.

S

 

[benallen105]

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 :

 

[Don Guillett]

Perfect! That got it. Thanks a lot Spencer

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.