| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protecting the worksheet
MySheet.Unprotect Password:="*****"
: MySheet.Protect Password:="*****" "Fawn" wrote in message ... I have a worksheet that I would like to record a macro to protect with a password and unprotect with a password. When I record the macro it will not give me the choice to enter a password before the sheet unprotect. Don't know if it is possible to do this. Does anyone have suggestion? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
protecting the worksheet
I have a worksheet that I would like to record a macro to protect with a
password and unprotect with a password. When I record the macro it will not give me the choice to enter a password before the sheet unprotect. Don't know if it is possible to do this. Does anyone have suggestion? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using VBA to create a new worksheet, and then target new worksheet | Excel Discussion (Misc queries) | |||
| Protecting a Worksheet but ability to Sort | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Linear Mode
