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
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