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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Protect Sheet but be able to merge cells" wrote:

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!!!