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.........
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.........