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: 914

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.



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.