Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Protecting Sheets
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password Protecting Sheets
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. "VoxBox-Richard" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protecting sheets in a workbook | Excel Worksheet Functions | |||
Password Protecting Sheets in Excel So Others Can't See Certain Sh | Excel Worksheet Functions | |||
Password protecting sheets through VBA | Excel Programming | |||
Protecting buttons with VB code rather than protecting sheets/books? | Excel Programming | |||
Protecting Multiple sheets with prompt for password to unprotect | Excel Programming |