Hi,

I've got this Workbook_Open code and I'd like to add a password i
order to unable the users to unprotect the sheets.
I just need one password for all the sheets.
Since I don't know how and where to put the password, your help vital.

I enclose the code.

Thank you!
Alex
Bad

Attachment filename: private sub workbook.txt
Download attachment: http://www.excelforum.com/attachment.php?postid=61655
--
Message posted from http://www.ExcelForum.com

Hi
use somehing like
....
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="yourpassword" 'and the other protect options
you may nee
next
....

--
Regards
Frank Kabel
Frankfurt, Germany


Hi,

I've got this Workbook_Open code and I'd like to add a password in
order to unable the users to unprotect the sheets.
I just need one password for all the sheets.
Since I don't know how and where to put the password, your help
vital.

I enclose the code.

Thank you!
Alex
Bad:

Attachment filename: private sub workbook.txt
Download attachment:
http://www.excelforum.com/attachment.php?postid=616555 ---
Message posted from http://www.ExcelForum.com/

Frank,

I tried and tried, but it goes in conflict with the existing protection
code.

Can you have a look to the existing code and let me know where am i wrong?

I'm sure there's too much into it if I add your code.

Thanks
Alex
"Frank Kabel" wrote in message
...
Hi
use somehing like
...
dim wks as worksheet
for each wks in activeworkbook.worksheets
wks.protect password:="yourpassword" 'and the other protect options
you may nee
next
...

--
Regards
Frank Kabel
Frankfurt, Germany


Hi,

I've got this Workbook_Open code and I'd like to add a password in
order to unable the users to unprotect the sheets.
I just need one password for all the sheets.
Since I don't know how and where to put the password, your help
vital.

I enclose the code.

Thank you!
Alex
Bad:

Attachment filename: private sub workbook.txt
Download attachment:
http://www.excelforum.com/attachment.php?postid=616555 ---
Message posted from http://www.ExcelForum.com/