Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect opening of worksheet
I've an excel file withe multiple sheets. I want to protect some of
them with a password to open it. Does someone have a script to arange this. (so when clicking on a password protected sheet a password question should be prompted) Thanks in advance. Bernd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect opening of worksheet
You mean so the user click on the tab of the sheet and before it is
activated, you get a password prompt? If so, this would be difficult to implement The actions are User clicks tab that sheet is activated the deactivate event of the previous sheet fires the activate event of the selected sheet fires as you see, the sheet is exposed before any events. I suspose you could immediately hide the sheet after it flashes into view using the deactivate event (possibly at the workbook level). Of course, this is easily defeated if the user disables macros. -- Regards, Tom Ogilvy "bernd" wrote in message oups.com... I've an excel file withe multiple sheets. I want to protect some of them with a password to open it. Does someone have a script to arange this. (so when clicking on a password protected sheet a password question should be prompted) Thanks in advance. Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
worksheet protect | Excel Worksheet Functions | |||
How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
No option to password protect opening an excel / word file | Excel Discussion (Misc queries) | |||
Auto Protect workbook with password upon opening | Excel Worksheet Functions |