Protect sheet but be able to merge cells

  • Thread starter Protect Sheet but be able to merge cells
  • 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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top