Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to protect with pword in 97
I've coded in excel xp, but it does not work if I open it
in excel 97. The code unprotects a page with a passowrd, changes some things, then protects it again. The code to protect I used was: Worksheets("Student List").Unprotect Pword .... some code ... Worksheets("Student List").Protect password:=Pword (Where Pword is a string constant) What do I need to change so that it works in 97? Thanks for any help you can give me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to protect with pword in 97
If you are running it from a comandbutton, then change the TakeFocusOnClick
property to False. -- Regards, Tom Ogilvy "Wes" wrote in message ... I've coded in excel xp, but it does not work if I open it in excel 97. The code unprotects a page with a passowrd, changes some things, then protects it again. The code to protect I used was: Worksheets("Student List").Unprotect Pword ... some code ... Worksheets("Student List").Protect password:=Pword (Where Pword is a string constant) What do I need to change so that it works in 97? Thanks for any help you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect then reprotect using macro | Excel Discussion (Misc queries) | |||
Protect macro from stopping | Excel Discussion (Misc queries) | |||
Protect macro for unauthorised use | Excel Discussion (Misc queries) | |||
Protect macro | Excel Discussion (Misc queries) | |||
How to protect my macro | Excel Discussion (Misc queries) |