Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passwords
I want to be able to use a password to protect the sheets. How do I write a
procedure that unprotects these sheets using a password? Also, I checked the box below to get notified by email when I get a reply, but I haven't been getting emails notifying me when a question is answered. What do I need to do? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passwords
Sheets("Sheet1").UnProtect Password:="tada"
Sheets("Sheet1").Protect Password:="tada" As for the e-mail thing... Not a clue... -- HTH... Jim Thomlinson "ranswrt" wrote: I want to be able to use a password to protect the sheets. How do I write a procedure that unprotects these sheets using a password? Also, I checked the box below to get notified by email when I get a reply, but I haven't been getting emails notifying me when a question is answered. What do I need to do? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passwords
Make sure your emails aren't gong to junk mail? If not that... beats me.
Along with Jim's code it should be noted that someone can open the VBA Editor and look at your password. To prevent this in the VBE (editor) go to Tools-VBA Project Properties. Select the Protection tab and select Lock Project for Viewing. Enter a password and click OK. -- -SA "ranswrt" wrote: I want to be able to use a password to protect the sheets. How do I write a procedure that unprotects these sheets using a password? Also, I checked the box below to get notified by email when I get a reply, but I haven't been getting emails notifying me when a question is answered. What do I need to do? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passwords
Thanks
"StumpedAgain" wrote: Make sure your emails aren't gong to junk mail? If not that... beats me. Along with Jim's code it should be noted that someone can open the VBA Editor and look at your password. To prevent this in the VBE (editor) go to Tools-VBA Project Properties. Select the Protection tab and select Lock Project for Viewing. Enter a password and click OK. -- -SA "ranswrt" wrote: I want to be able to use a password to protect the sheets. How do I write a procedure that unprotects these sheets using a password? Also, I checked the box below to get notified by email when I get a reply, but I haven't been getting emails notifying me when a question is answered. What do I need to do? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passwords | Excel Discussion (Misc queries) | |||
Add-ins passwords | Excel Programming | |||
passwords | Excel Programming | |||
Passwords | Excel Programming | |||
Passwords | Excel Programming |