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

Protect Sheet but be able to merge cells;373301 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!!!

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


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=104489

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

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

--

Dave Peterson

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