| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro
I need a macro command to unprotect cells A6:O6. I don't won't to unprotect
the whole Sheet could someone help me ? Thank Ken |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro
Cells are locked or unlocked - but to change that setting you have to
unprotect the worksheet Activesheet.Unprotect Password:="ABC" cells.Locked = True Range("A6:O6").Locked = False Activesheet.Protect Password:="ABC" -- Regards, Tom Ogilvy "holy41" wrote: I need a macro command to unprotect cells A6:O6. I don't won't to unprotect the whole Sheet could someone help me ? Thank Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Linear Mode
