| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to unlock worksheet
I want my macro to unlock the worksheet before it runs, and then lock it
again after. At the moment I have Sheets("Daily Report").Select wsheet.Unprotect Password:="computer" however this is getting an error. Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to unlock worksheet
Kirsty,
Do it like this Sheets("Daily Report").Unprotect Password:="computer" 'do things Sheets("Daily Report").Protect Password:="computer" Mike "Kirsty" wrote: I want my macro to unlock the worksheet before it runs, and then lock it again after. At the moment I have Sheets("Daily Report").Select wsheet.Unprotect Password:="computer" however this is getting an error. Any suggestions? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to unlock worksheet
thanks, works perfectly
"Mike H" wrote: Kirsty, Do it like this Sheets("Daily Report").Unprotect Password:="computer" 'do things Sheets("Daily Report").Protect Password:="computer" Mike "Kirsty" wrote: I want my macro to unlock the worksheet before it runs, and then lock it again after. At the moment I have Sheets("Daily Report").Select wsheet.Unprotect Password:="computer" however this is getting an error. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unlock worksheet | Excel Discussion (Misc queries) | |||
| How do I program a macro to unlock and relock an excel worksheet | Excel Programming | |||
| How do I program a macro to unlock and relock an excel worksheet | Excel Programming | |||
| Unlock protected worksheet | Excel Programming | |||
| how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and access a .xls from another .xls macro. | Excel Worksheet Functions | |||
Linear Mode
