View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MrAlMackay MrAlMackay is offline
external usenet poster
 
Posts: 17
Default 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
( )