| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need a macro to lock sheet
I would like a simple macro that inserts my password into the 2 protection
fields when locking the sheet. When I go to unprotect the sheets the file doesn't ask for the password? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
need a macro to lock sheet
Activesheet.Protect Password:="ABC"
Activesheet.Unprotect Password:="ABC" are the commands. Just another thought. You need to save the workbook before closing if you want them to be in effect when you open it. -- Regards, Tom Ogilvy "dgr" wrote: I would like a simple macro that inserts my password into the 2 protection fields when locking the sheet. When I go to unprotect the sheets the file doesn't ask for the password? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to unlock and lock cells in password protected sheet | Excel Discussion (Misc queries) | |||
| Write macro to lock selected sheet when run | Excel Discussion (Misc queries) | |||
| is it possible to record a macro that would lock a sheet | Excel Discussion (Misc queries) | |||
| HOW TO LOCK THE OPENING OF A SHEET(TAB)? | Excel Discussion (Misc queries) | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Linear Mode
