Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save protected file into unprotected file without password
I have a master workbook file which is password protected.
I want to create a procedure that a user access and save the protected template file into his/her own unprotected file before he/she start updating the file without password entry. I have recorded an "ActiveSheet.Unprotect" macro. However, I was ask to enter the "Password" when I ran the macro. Is it possible to create a macro which unprotects and saves the file into a new unprotected file without password entry? There is no purpose protecting the file if I have to let all users know the password. Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XLS password protected file | Excel Discussion (Misc queries) | |||
Link to a password protected file | Excel Discussion (Misc queries) | |||
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) | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |