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