View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Robert McCurdy Robert McCurdy is offline
external usenet poster
 
Posts: 102
Default merging cells in a protected work sheet

There was this guy in India who rolled across the continent on his back.
Using merged cells is like that - you can but for Gods sake WHY?!

activesheet.protect Password:="", UserInterfaceOnly:=True
'code to merge

In case you change your mind ;)
Code to unmerge - [B2:D4].UnMerge


Regards
Robert McCurdy

"EG" wrote in message ...
is it possible to merge cells in a protected worksheet?

Eric