Macro problem

nancyo · Mar 27th, 2002, 08:43 AM

I have an excel spreadsheet with 2 simple macros, which run in a specific order. Both macros unprotect the spreadsheet as the first step, and protect with the last step (password is included in code). After I run the first macro, if I go to unprotect the sheet, I am NOT prompted for a password. If I run the second macro, and then try to unprotect the sheet, I am prompted for a password. The macros both have the same language...???

Juan Pablo González · Mar 27th, 2002, 08:50 AM

The .Protect and .Unprotect methods have an optional parameter which is the password. Are you sure you're supplying it when you unprotect and when you re-protect ?

nancyo · Mar 27th, 2002, 08:59 AM

Yes - both macros are identical with regards to the protect, unprotect. I am begining to think it is a glitch.

Mar 27th, 2002, 08:50 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	The .Protect and .Unprotect methods have an optional parameter which is the password. Are you sure you're supplying it when you unprotect and when you re-protect ? __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Mar 27th, 2002, 08:43 AM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I have an excel spreadsheet with 2 simple macros, which run in a specific order. Both macros unprotect the spreadsheet as the first step, and protect with the last step (password is included in code). After I run the first macro, if I go to unprotect the sheet, I am NOT prompted for a password. If I run the second macro, and then try to unprotect the sheet, I am prompted for a password. The macros both have the same language...???

Mar 27th, 2002, 08:59 AM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Yes - both macros are identical with regards to the protect, unprotect. I am begining to think it is a glitch.