protection with password in macro

[imported_unknown]

Hi, I'm having a protection issue.
When you protect your sheet with "Extra/Protect/Protect Worksheet" you get the chance to enter a password. But now I want to protect the sheet in a macro with "ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True". Does anyone know if and how I can throw in an password? If possible, I'd even like to use a predefined password in a hidden row, is this doable?
I'm still a rookie at this, maybe there's an easier solution. Please let me know.
This message was edited by Andy on 2002-10-03 21:03

 

[Legacy 98055]

Hi Andy.
<pre>
'either syntax will do
'For ex. Password in located in cell IV1 on the activesheet
Sheet1.Protect [IV1], True, True, True
Sheet1.Protect PassWord:=[IV1], DrawingObjects:=True, Contents:=True, Scenarios:=True

</pre>
Tom

 

[imported_unknown]

Thx Tom, great stuff !!