P
Paul
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
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