Hi - can anybody help me. I need to unprotect a worksheet, amend it and then protect it again. The rest of the vba runs fine but I don't know how to include the password into the code so it doesn't have to entered manually as the code runs.
I'm very new to vba so any help is much appreciated.
Thanks in advance.
Charles
[vba]
Activesheet.Unprotect Password:="my_Password"
'do your stuff
Activesheet.Protect Password:="my_Password"
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
