How can I merge unprotected cells in a protected worksheet?

's Computer Specifications

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

's Computer Specifications

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
<(E-Mail Removed)> wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Delete unprotected cells in protected worksheet	Len Silva	Microsoft Excel Worksheet Functions	1	30th Jul 2008 02:24 PM
How can I have formatting options like merge cells ,Bold,active for the unlocked cells of the protected worksheet.Is it possible in excel?	divya	Microsoft Excel Programming	2	20th Jul 2006 02:04 PM
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet???	sanam	Microsoft Excel Misc	6	20th Jul 2006 01:42 PM
Protected worksheet with unprotected cells i.c.w. remarks	=?Utf-8?B?RnJhbmtPdHRlcjY4?=	Microsoft Excel Worksheet Functions	1	17th Apr 2006 04:21 AM
Move cursor through all unprotected cells in a protected worksheet	=?Utf-8?B?Qm9iIFNpbXBzb24=?=	Microsoft Excel Misc	9	18th Nov 2005 06:50 PM