Merging cells in a protected worksheet

I came across something interesting... I have a worksheet and it is protected. I have added the standard code:

mysheet.EnableSelection = xlUnlockedCells
mysheet.Protect AllowFormattingCells:=True

to protect it.

eventhough the worksheet is protected, I would like to allow the user to merge cells of unlocked cells, but it is "greyed" out in the format cells. Has anyone else come accross this and is there a way to solve it.

Hi

Not all formatting is allowed on a protected sheet. This is one of those things that you just cannot do on a protected sheet, even if you have enabled formatting.

Do you need to format the cell because of the amount of text? If so you can still wrap the text of change horizontal alignment to 'centre across selection'.

Hope this helps.
Jon von der Heyden