I have a sheet called "blank" (password protected) which I programatically copy to a new sheet. I would like the user to be able to edit this new sheet, but not edit the blank sheet. I tried activesheet.unprotect, but of course it asks for the password. How can I make an unpassword protected copy of a password protected sheet without entering the password?
Thanks,
Dave
Not entirely sure what you need but maybe
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
ah perfect, I didn't know you could pass unprotect() the password ! haha
I guess it's not too secure since it's plain text in the code, but my users dont know how to get into the macro code! hahaha
You can password protect the VBA code so they can't read it without putting in the password, too.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
To protect your code, first open the VB Editor & select the relevant workbook.
Go to Tools -> VBAProject properties, lock the project for viewing, and enter a password.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks