How can I merge unlocked cells in a worksheet that has been protec
 

In my worksheet, I turned on "Protect Sheet" so that users can't view or
modify locked cells.

But since I still wanted them to be able to modify unlocked cells any way
they wanted, I selected all the options in the list of "Allow all users of
this worksheet to" features in the "Protect Sheet" dialogue box (except for
"select locked cells" obviously).

However, the users can't seem to merge unlocked cells. Is there a way of
including this functionality in the allowed actions?

You could create a macro to unprotect the sheet, merge the selected
cells, and reprotect the sheet.

But I'd be happy that they can't merge cells. Merged cells can create
problems in a worksheet.

NeedMergeHelp wrote:
In my worksheet, I turned on "Protect Sheet" so that users can't view or
modify locked cells.

But since I still wanted them to be able to modify unlocked cells any way
they wanted, I selected all the options in the list of "Allow all users of
this worksheet to" features in the "Protect Sheet" dialogue box (except for
"select locked cells" obviously).

However, the users can't seem to merge unlocked cells. Is there a way of
including this functionality in the allowed actions?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I, too, hate merged cells and I do my best not to use them.

But you could give the users another worksheet with a merged cell on it (same
dimensions that you need).

Then tell them to copy|paste special|formats to the "real" sheet.

(In fact, some of your users may figure this out for other formatting and really
cause you heartache!)

NeedMergeHelp wrote:

In my worksheet, I turned on "Protect Sheet" so that users can't view or
modify locked cells.

But since I still wanted them to be able to modify unlocked cells any way
they wanted, I selected all the options in the list of "Allow all users of
this worksheet to" features in the "Protect Sheet" dialogue box (except for
"select locked cells" obviously).

However, the users can't seem to merge unlocked cells. Is there a way of
including this functionality in the allowed actions?


--

Dave Peterson