| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting merged cells via Macro
Hi,
Hopefully a simple question. How can I change the protection on merged cells? The following line of code gives me an error if there are merged cells in the named range, but works fine if the named range contains no merged cells: range("mergedcells").locked = true Thanks in advance Shane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Jim Rech's macro won't work (autofitting merged cells) | Excel Discussion (Misc queries) | |||
| Macro Paste Special Merged Cells | Excel Programming | |||
| Need macro to autofit height for merged cells | Excel Programming | |||
| pasting into merged cells with a macro | Excel Programming | |||
| Protecting merged cells | Excel Programming | |||
Threaded Mode
