PDA

View Full Version : Add different password(S) to worksheet(s) from workbook



Pete
08-14-2008, 12:58 AM
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.........