Merging cells in a Protected Sheet

[Protect Sheet but be able to merge cells]

Does anyone know how to Merge cells once you have protected a sheet? There is
the option to 'allow users to format cells', but for some reason it will not
let me merge cells!!!

 

[Pecoflyer]

Does anyone know how to Merge cells once you have protected a sheet?
There is
the option to 'allow users to format cells', but for some reason it
will not
let me merge cells!!!

Hi,
be aware that merged cells are nothing but trouble if you want to use
them to retrieve data or whatever.
Except for cosmetic purposes avoid them if possible.
You can try to format horizontal - Center across selection

 

[Dave Peterson]

There are some things that aren't available in protected worksheets.

Merging cells is in that group.

If you really, really want to (I wouldn't!), maybe you could provide a macro
that:
unprotects the sheet
merges the cells you want merged
reprotects the sheet

 

[Shane Devenshire]

Hi,

The basic macro would be

Sub MyMerge()
ActiveSheet.Unprotect
Selection.Merge
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

If you have a password then check the VBA Help for Unprotect or Protect.