Good morning.
I currently use a code that will go through multiple worksheets and save each one as an individual workbook whilst password protecting the document. I want to set part of the password for each workbook as referencing a specific cell value in that workbook, the cell will always be the same (A2) but the value in the cell is different in each sheet. is this possible? if so how?
for example the password format would be "XXX (Cell A2)" with XXX being the same for each workbook.
Many thanks in advance.
Bookmarks