| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro , Unprotect-Protect -- Atten: Tom Ogilvy
Hi Tom
Thankyou for your help on this yesterday. I put the following in my macro: (at the start) Worksheets("abc").Unprotect (at the end) Worksheets("abc").Protect Basicly this works fine with one major problem. You can't protect the sheet with a password. If you do, you have to enter the password befor you can run the macro. Then the password protection is gone. What I need is this. After the above macro is run, I need not only the sheet to be protected but still be protected with a password. So that only the person that knows the password can change a cell. That person being me. Can this be done? Thankyou Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro , Unprotect-Protect -- Atten: Tom Ogilvy
Hi Ed
Look in the VBA help for Protect You can use a password in your code Worksheets("abc").Protect Password:="password" -- Regards Ron de Bruin http://www.rondebruin.nl "Ed" wrote in message ... Hi Tom Thankyou for your help on this yesterday. I put the following in my macro: (at the start) Worksheets("abc").Unprotect (at the end) Worksheets("abc").Protect Basicly this works fine with one major problem. You can't protect the sheet with a password. If you do, you have to enter the password befor you can run the macro. Then the password protection is gone. What I need is this. After the above macro is run, I need not only the sheet to be protected but still be protected with a password. So that only the person that knows the password can change a cell. That person being me. Can this be done? Thankyou Ed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro , Unprotect-Protect -- Atten: Tom Ogilvy
Worksheets("abc").Unprotect Password:="ABCD"
Worksheets("abc").Protect Password:="ABCD" -- Regards, Tom Ogilvy "Ed" wrote in message ... Hi Tom Thankyou for your help on this yesterday. I put the following in my macro: (at the start) Worksheets("abc").Unprotect (at the end) Worksheets("abc").Protect Basicly this works fine with one major problem. You can't protect the sheet with a password. If you do, you have to enter the password befor you can run the macro. Then the password protection is gone. What I need is this. After the above macro is run, I need not only the sheet to be protected but still be protected with a password. So that only the person that knows the password can change a cell. That person being me. Can this be done? Thankyou Ed |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro , Unprotect-Protect -- Atten: Tom Ogilvy
Thanks Tom and Ron
Works Great. Ed -----Original Message----- Worksheets("abc").Unprotect Password:="ABCD" Worksheets("abc").Protect Password:="ABCD" -- Regards, Tom Ogilvy "Ed" wrote in message ... Hi Tom Thankyou for your help on this yesterday. I put the following in my macro: (at the start) Worksheets("abc").Unprotect (at the end) Worksheets("abc").Protect Basicly this works fine with one major problem. You can't protect the sheet with a password. If you do, you have to enter the password befor you can run the macro. Then the password protection is gone. What I need is this. After the above macro is run, I need not only the sheet to be protected but still be protected with a password. So that only the person that knows the password can change a cell. That person being me. Can this be done? Thankyou Ed . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Modifying a protect unprotect macro | Excel Discussion (Misc queries) | |||
| Macro to Protect OK, Unprotect now messed up! | Excel Worksheet Functions | |||
| protect / unprotect VBA project by macro | Excel Discussion (Misc queries) | |||
| Unprotect and protect sheet in a macro | Excel Programming | |||
| Macro to protect and unprotect | Excel Programming | |||
Linear Mode
