Hello:
I have lots of excel file.
All these files need to be protected with the password with a macro to avoid doing it manually as there are lots of file.
I will have Password in Sheet1 of cell A1 of each file.
Please let me know if you have any questions.
Thanks.
Riz
Hello Riz,
If you are protecting individual workbooks, where do you have the paths?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith:
All files will be either .xls or .xlsm
Each file will have say "Sheet1" and each will have PW in cell A1.
Let's say i have 100 Files in C:\Temp\ folder.
Currently all files are unprotected.
Now rather then opening up each file manually and adding PW will take long time.
So i need a VB Macro to go thru each Closed file and get the Pw from Sheet1, Cell A1 and save that file with the PW.
I hope this clears my requirement.
Please let me know if you have any questions.
Thanks.
Riz
Hello Riz,
You will need to change Path to the folder where the files are. This open all xls, xlsx, and xlsm files and set the passwords using cell "A1" on "Sheet1".
Please Login or Register to view this content.
Last edited by Leith Ross; 11-06-2015 at 08:06 PM. Reason: Corrected Typo
Hi Leith :
I am getting error at " Files.Filter 64, "*.xls;*.xlsx;*.xlsm" "
I have 2 files in C:\Temp1 namely Book1.xlsx and Book2.xlsx
i have changed the path to C:\Temp1
Please refer to atatched files.
Riz
Hello Riz,
My fauilt. It is typographical error.
Change Files.Filter 64, "*.xls;*.xlsx;*.xlsm" to oFiles.Filter 64, "*.xls;*.xlsx;*.xlsm".
Hi Leith:
Its working great except small issue.
It is asking to enter the PW twice, need to enter just once if possible.
Thanks
Riz
Hello Riz,
You shouldn't be prompted for the password. When are you receiving the prompts: Workbook Open, Workbook Close, or both?
Hi Leith:
Yes you are correct.
When I try to open it ask the PW twice instead of 1 time.
Thanks
Riz
Hello Riz,
The macro just assigns the password to the workbook. Once the workbook has a password you will prompted to enter the password when the workbook is opened.
Are you entering it a second time as a confirmation to the first entry?
Hi Leith:
I am sorry to get back late.
Yes, I entering it a second time as a confirmation to the first entry.
This will work....Thanks a lot
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks