Saving seprate worksheets with password using VBA?
I have VBA code that will save each worksheet as seperate files using the tab name and a password. The trouble is all the new files have the same password. I need the password in the VBA code to be assigned to a variable that changes with each FOR loop. Any ideas how I can do that please?
Be the first to answer this question.