Passwords

Nigel Martin · Feb 19th, 2002, 01:07 AM

Is it possible whilst running a macro to un-protect a password protected worksheet without the user being prompted to enter a password, then running whatever macro code has been written, then re-protecting the worksheet with the same password, again without the user being prompted for a password?

Tom Urtis · Feb 19th, 2002, 01:10 AM

The general syntax within your procedure could be something like:

ActiveSheet.Unprotect ("PASSWORD")
'Your code goes here
ActiveSheet.Protect ("PASSWORD")

Of course, modify for actual password characters.

Tom Urtis

Nigel Martin · Feb 21st, 2002, 01:05 AM

Many Thanks Tom, it works well.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 19th, 2002, 01:07 AM	#1
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Is it possible whilst running a macro to un-protect a password protected worksheet without the user being prompted to enter a password, then running whatever macro code has been written, then re-protecting the worksheet with the same password, again without the user being prompted for a password?

Feb 19th, 2002, 01:10 AM	#2
Tom Urtis MrExcel MVP Join Date: Feb 2002 Location: San Francisco, California USA Posts: 10,382	The general syntax within your procedure could be something like: ActiveSheet.Unprotect ("PASSWORD") 'Your code goes here ActiveSheet.Protect ("PASSWORD") Of course, modify for actual password characters. Tom Urtis

Feb 21st, 2002, 01:05 AM	#3
Nigel Martin Board Regular Join Date: Feb 2002 Posts: 133	Many Thanks Tom, it works well.