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?

There are no answers yet.
Be the first to answer this question.