Password Protecting Sheets

  • Thread starter Thread starter VoxBox-Richard
  • Start date Start date
V

VoxBox-Richard

Hello,

Is there a way I can password to protect a sheet so that before it can be
viewed a password has to be entered? I don't want to hide the tab and I have
already locked it (so the data can't be edited). I would like to protect the
viewing of the tab- I cant think of a way to do this using the normal excel
functions so VBA must be the answer. Can any one shed any light?

Cheers.

Richard
 
I dont know of any way to stop a visible sheet from being viewed...I mean
when the visible property is true, then thats saying show the worksheet to
the user.

Now if you want to force it then possibly....

In VBA, what I would try is write some code for the sheet's activation. You
can save the sheet filled with a color, and then based upon activation code,
to unfill that color. You would also have to write a deactivation code to
fill it back also of course.
 
Back
Top