Hi...
I hv one query...
I gave every workbook one same password and send it to my client. But I don't want that when ever i open that file it will not ask me the password. So is their any vba code which consist my master password and when i open that workbook it will automatically gave it and directly open that file for me...... ???
Hi,
This code will loop through your workbook, and unprotect each sheet, provided they all have the same password. Just enter that password where indicated by red text
Hope this helps, please let me know!
Please Login or Register to view this content.
Regards,
David
When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
Hi, pwnyadav007,
from what I read you would need to create a workbook from which you open the other workbooks (or use the personla macro workbook or an addin). This WB should offer a dialogue/GetOpenFilename to choose the workbook and pass the parameter of the password when opening the workbook.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks