Thanks, Robert. I have a spread sheet that i have some fairly complex
functions in one part of it, which i want to protect from being changed. in
the other part of the sheet i want people to be able to manipulate and merge
cells as they need to. Do i need to select the cells i want people to be
able to change and then type: :
="", UserInterfaceOnly:=True ??

Thanks for your help!

Eric


"Robert McCurdy" wrote:

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