JBurwell83
New Member
- Joined
- May 22, 2018
- Messages
- 1
Hi,
My first post in this forum, so please be gentle.
I have a client that has a workbook of c700 spreadsheets for which I have found a code to seperate the workbook each month into individual spreadsheets and then save in a folder and distribute accordingly.
I am now looking to encrypt a password ideally as a bulk to each of these spreadsheets for which will all be in the same folder if that helps.
What’s the best process amend the original code so when it splits up the spreadsheets to then apply a password or is there an alternative solution as don’t fancy adding a password to each of the 700 sheets each month.
The password i am looking for is to be applied so the recipient can view/open the spreadsheet rather than password protect the data from being amended.
Happy to share the existing code if that helps
Many Thanks in advance to anyone that can help.
James
My first post in this forum, so please be gentle.
I have a client that has a workbook of c700 spreadsheets for which I have found a code to seperate the workbook each month into individual spreadsheets and then save in a folder and distribute accordingly.
I am now looking to encrypt a password ideally as a bulk to each of these spreadsheets for which will all be in the same folder if that helps.
What’s the best process amend the original code so when it splits up the spreadsheets to then apply a password or is there an alternative solution as don’t fancy adding a password to each of the 700 sheets each month.
The password i am looking for is to be applied so the recipient can view/open the spreadsheet rather than password protect the data from being amended.
Happy to share the existing code if that helps
Many Thanks in advance to anyone that can help.
James
