Macro to add password based on cell value

Hello,

I have a workbook which contains several sheets that are emailed to individual end users (each user has their own sheet). I have a macro that copies each sheet and emails based on the email within the sheet. What I want to do now is add a password to each created sheet based on a value that is in cell G3. So in the end everyone gets their own data that has a unique password.

Here is the code so far:

Please Login or Register  to view this content.

Thank you!

Figured it out by adding this:

Please Login or Register  to view this content.