Protected Worksheet Not retaining Formatting on Text Drag default behavior.

[bstone]

I have a worksheet that is protected.
There is a section of cells that are unlocked to make entries in.

When I select some text and move it (by dragging the text from on
place to the next.) The formatting (Cell Borders) are removed from th
place where the original text was.

It is performing a cut-n-paste for me automatically

I would like to Change this behavior so that the formatting is no
removed during the cut and paste.

Is there anyway to control the default paste behavior in thi
workbook/worksheet

 

[Jim Rech]

By definition a Cut and Paste moves a range and all of its attributes
including formats. You cannot change this. About all you can do is use
macros to remove Cut from all menus, disable Drag and Drop and kill the
keyboard shortcuts. Quite a hassle.

--
Jim Rech
Excel MVP
|I have a worksheet that is protected.
| There is a section of cells that are unlocked to make entries in.
|
| When I select some text and move it (by dragging the text from one
| place to the next.) The formatting (Cell Borders) are removed from the
| place where the original text was.
|
| It is performing a cut-n-paste for me automatically
|
| I would like to Change this behavior so that the formatting is not
| removed during the cut and paste.
|
| Is there anyway to control the default paste behavior in this
| workbook/worksheet?
|
|
| ---
| Message posted
|

 

[bstone]

Thank