Excel Macro; Adding Password [Solved/Closed]

zeromaim 10 Posts Monday July 28, 2008Registration date August 8, 2008 Last seen - Jul 29, 2008 at 10:51 AM - Latest reply:  Pujdo
- Mar 13, 2013 at 10:39 AM
Hello,

Hope you anyone can help me with this...

I need to create a macro that unlocks a password-protected sheet with password "password", do some instruction, then locks it again with same password.

Thanks in advance for any assistance.

zero
See more 

13 replies

Best answer
Ivan-hoe 436 Posts Saturday February 16, 2008Registration date October 17, 2008 Last seen - Aug 5, 2008 at 12:45 PM
13
Thank you
Hello zero,
the syntax is quite simple
ActiveSheet.Unprotect ("MyPassWord")
'instructions
ActiveSheet.Protect ("MyPassWord")

for more details, I suggest you type "worksheet.protect" and "worksheet.unprotect" in the help file of visual basic editor.
Ivan

Thank you, Ivan-hoe 13

Something to say? Add comment

CCM has helped 1705 users this month

zeromaim 10 Posts Monday July 28, 2008Registration date August 8, 2008 Last seen - Aug 6, 2008 at 07:22 AM
Hi Ivan,

Thanks for this, and other one as well.
I'm not actually a programer. I self-studied excel and i'm good at using formulas.
I just recently learn about macro and I used to just for recording to eliminate the circular ref error with formulas.
I was glad to have found this site and have read one of your response.

Thanks,

Anton
The ActiveSheet.Protect ("MyPassWord") works, but what if you want the set certain "abilities" to True when assigning the password as in the following code.

ActiveSheet.Protect ("MyPassWord") DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowSorting:=True, AllowFiltering:=True, AllowUsingPivotTables:=True

This errors out when the Macro is ran. Is there a different Syntax for a case like this?
Ivan-hoe 436 Posts Saturday February 16, 2008Registration date October 17, 2008 Last seen > DaveyBoy - Oct 8, 2008 at 06:46 AM
Hello,
try this syntax :
ActiveSheet.Protect PassWord:="MyPassWord", DrawingObjects:=True,  _ 
Contents:=True,  Scenarios:=True, AllowSorting:=True, AllowFiltering:=True,  _ 
AllowUsingPivotTables:=True 

Ivan
Josh > Ivan-hoe 436 Posts Saturday February 16, 2008Registration date October 17, 2008 Last seen - Sep 9, 2009 at 07:12 AM
Hey Ivan valuable info on your post. Thanks pal.
thanks Ivan...ur post was a real help :)
zeromaim 10 Posts Monday July 28, 2008Registration date August 8, 2008 Last seen - Aug 8, 2008 at 07:30 AM
1
Thank you
Thanks Ivan.

How do I change the status of this topic to "resolved"?

Anton
aquarelle 7183 Posts Saturday April 7, 2007Registration dateModeratorStatus May 25, 2018 Last seen - Aug 8, 2008 at 03:30 PM
Hi,
Go to the top of your thread (to the right part), and check the case "solved" after click on "OK"
Best regards
1
Thank you
Thanks Ivan!
i want those number in front add ''0" (Zero) how to 456789
11111
22222
33333
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Jul 28, 2010 at 10:14 AM
Ram: what this question "i want those number in front add ''0" (Zero) how to 456789 11111 22222 33333", has to do with the thread ?
0
Thank you
how to remove the xsl sheet password
0
Thank you
Tnx for this :) this is working for me :)