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 ( ) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Al,
If you attempt to unprotect a password-protected sheet without supplying the password, Excel will automatically prompt for the password. ActiveSheet.Unprotect -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "MrAlMackay" wrote in message ... Dave Don't actually want the spreadsheet to be unprotected through the macro. I only want to get to the dialog box (@ this point I would need the macro to end) as this is when the user would type in the password or alternatively if it isn't one of the administrators they would exit out. Is it possible to get the dialog box through VBA? Appreciate your help on this. Many Thanks, Al |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Cheers for your help with this.
Worked a treat. Thanks, Al. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Have a similar issue but want to call the the Protect Sheet dialog box
via VBA to allow the user to enter a password if desired - can someone advise how I might do this? Thanks! Jeff |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password - Protect, UnProtect
Thanks Ben - I'll give that a try but wanted to clarify - Did you mean
that this will only work in Excel 2003? If so, are there other solutions for Excel 97, 2K & XP? Am wanting this code to work across all versions from 97 onwards ... Jeff |
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) |