-
Add different password(S) to worksheet(s) from workbook
see attached workbook
Hi
Currently, the workbook password is Phoenix.......
However, when the user clicks in the first worksheet "Pricing Template" the send macro button a report is generated which then is emailed to any mail recipant... when they receive and open up the report to un protect the worksheet/book the password is still "Phoenix"........
Here is the question:
I want to add a differenet passwword to this worksheet but keep the workbook password still as "Phoenix".....
So add to worksheet "Pricing Template" new password = Pricing Template......
so if the user tries to amend the cell contents then userform (frm__password_prcing) appears asking for user to enter password before they can amend the worksheet......
1. User press ok without password msgbox "Please Enter Valid Password"...
2. User presses cancel then exit.........
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules