Hi ,
Can u help me with the attached ZIP file Macro,
I am using the Macro,"Create a new workbook for all Unique values in a newly created folder" from the ZIP file,
However I also wanted an addition in it, The new excel file created needs to be password protected.
The password can be vlookup based on the unique identifier "Country Name" as given in the macro from a new tab Passwords and if country name is not there in the tab passwords, there should be msg box to enter password.
Thanks
Bookmarks