Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a Password?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a Password?
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a Password?
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retrive password protected worksheet but forgot password? | Excel Worksheet Functions | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions | |||
bypass password when update linking of password protected file | Excel Discussion (Misc queries) | |||
Excel password but cant hide the sheets before entering password | Excel Programming | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |