Protect sheet but be able to merge cells

  • 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

Can anyone let me know if it is possible to protect a sheet, but still be
able to merge certain cells. I tried to allow users the access to 'format
rows' and 'format cells', but it wont allow me to merge cells.
 
First, I do my best to avoid merged cells. They cause trouble with copy|paste,
sorting, filtering, and lots of other stuff.

Maybe you can provide a macro that unprotects the sheet, merges the cells, and
then reprotects the sheet.
 
Back
Top