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

Format change in merge data - Bold formatting after a comma 0
Merging from an Excel file with graphics 1
I can still select & manipulate locked & protected cells in '07 1
Copying cells in a protected worksheet 2
Disabling "cut" function - version 2003/2007 1
Inserting pictures into unprotected range in a protected worksheet 1
To protect all worksheet simultaneously in a excel workbook 1
Allowing sort of protected cells 1

Top