| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection sheet
Hello all
When I runs my VBA macro there is an error because it works in a cell bloqued. How can I use the macros in this cell boqued? Thanks a lot henpat |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protection sheet
At the start of your macro code put this:
Worksheets("SheetName").Unprotect At the end, turn protection back on Worksheets("SheetName").Protect Use the actual sheet name, of course. -- - K Dales "henpat" wrote: Hello all When I runs my VBA macro there is an error because it works in a cell bloqued. How can I use the macros in this cell boqued? Thanks a lot henpat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| sheet Protection | Excel Discussion (Misc queries) | |||
| Sheet Protection | Excel Worksheet Functions | |||
| Sheet protection error msg - Unrequested sheet activation | Excel Programming | |||
Linear Mode
