View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How can I merge unprotected cells in a protected worksheet?

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

On Tue, 27 Apr 2010 14:56:01 -0700, cnaval
wrote:

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