Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Could anyone help me with the below:
Would like to have a macro that does the following: 1) Goes to the Unprotect Sheet dialog box where the user will need to enter in the password. 2) Also would like this macro to load up automatically when I open my spreadsheet. I know I can use Auto_Open however I want to call this macro within the Auto_Open macro. Appreciate your help on the above, Many Thanks - Al Mackay ( ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Problem with using macros and unprotect commands is that you can see the
password in your vba code, have password typed in as varable. Dave "MrAlMackay" wrote in message ... Could anyone help me with the below: Would like to have a macro that does the following: 1) Goes to the Unprotect Sheet dialog box where the user will need to enter in the password. 2) Also would like this macro to load up automatically when I open my spreadsheet. I know I can use Auto_Open however I want to call this macro within the Auto_Open macro. Appreciate your help on the above, Many Thanks - Al Mackay ( ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect/unprotect a formula | Excel Worksheet Functions | |||
Protect, unprotect | Excel Discussion (Misc queries) | |||
Protect/unprotect all sheets at once? | New Users to Excel | |||
Code to protect/unprotect a sheet using a macro with password | Excel Discussion (Misc queries) | |||
Protect / Unprotect with checkbox | Excel Discussion (Misc queries) |