Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How can I merge unprotected cells in a protected worksheet?

I have a protected worksheet that allows users to edit unprotected cells.
Each cells can be formatted but not merge.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protected/Unprotected Cells LtGator Excel Discussion (Misc queries) 0 August 10th 09 07:01 PM
Delete unprotected cells in protected worksheet Len Silva Excel Worksheet Functions 1 July 30th 08 02:24 PM
How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? sanam Excel Discussion (Misc queries) 6 July 20th 06 01:42 PM
Protected worksheet with unprotected cells i.c.w. remarks FrankOtter68 Excel Worksheet Functions 1 April 17th 06 04:21 AM
Move cursor through all unprotected cells in a protected worksheet Bob Simpson Excel Discussion (Misc queries) 9 November 18th 05 06:50 PM


All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"