Merging cells in a Protected Sheet

  • Thread starter Thread starter Protect Sheet but be able to merge cells
  • Start date Start date
P

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!!!
 
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
 
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.
 
Back
Top