How can I merge unprotected cells in a protected worksheet?

C

cnaval

I have a protected worksheet that allows users to edit unprotected cells.
Each cells can be formatted but not merge.
 
G

Gord Dibben

You cannot merge cells on a protected worksheet even if the cells are
unlocked.

Count yourself fortunate.

Now you won't have those merged cells which cause no end of problems.


Gord Dibben MS Excel MVP
 

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

Similar Threads

I can still select & manipulate locked & protected cells in '07 1
Inserting pictures into unprotected range in a protected worksheet 1
Delete unprotected cells in protected worksheet 1
use source formatting with protected worksheet 2
Copying cells in a protected worksheet 2
Allowing sort of protected cells 1
Protected worksheet with unprotected cells i.c.w. remarks 1
Disabling "cut" function - version 2003/2007 1

Top