• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro to add password in new excel sheets

akshay8530

New Member
Hi,


i have an macro which creates separate new excel file on the unique name criteria in particular row.


For Eg I have an data from Col A to F. The data is filtered on basis of Col A , and new excel id created on basis of unique id in Col A.


Now I want that new files created should be password protected, and there has to be vlookup of password from main file tab password and if unique name is not there than it will ask for password


Thanks
 
Back
Top