C cnaval Apr 27, 2010 #1 I have a protected worksheet that allows users to edit unprotected cells. Each cells can be formatted but not merge.
I have a protected worksheet that allows users to edit unprotected cells. Each cells can be formatted but not merge.
G Gord Dibben Apr 28, 2010 #2 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
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