Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Hide sheet tabs

  Asked By: Lucas    Date: Dec 04    Category: MS Office    Views: 881
  

How to hide the sheet tabs without the option to unhide it using the
tool>option menu or through format>sheet>unhide and also has an option
to unhide it back



Have tried using the worksheet properties and change to
xlsheetveryhidden but the problem is that I cannot retrieve the external
data to that hidden sheets



And is there any ways that I can hide all the formula too?



Any ideas cause already tried Google and getting nowhere.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Lonnie Rogers     Answered On: Dec 04

I would suggest hide  the worksheet, and password protect the workbook.
You can unlock the workbook and retrieve  your data via a sub routine.

 
Didn't find what you were looking for? Find more on Hide sheet tabs Or get search suggestion and latest updates.




Tagged: