View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shane in Canberra Shane in Canberra is offline
external usenet poster
 
Posts: 1
Default 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