| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you prevent Copy-Paste from changing formatting without macros
€¦specifically, in a worksheet that is protected, with only "select unlocked
cells" granted to users. The situation: the users are not granted €śformat cells€ť, which has been confirmed by attempting to manually apply bold, italic, or border changes. The sheet is created from an Excel template that has all of the intended formatting and protection in place. Observed behavior: if a user pastes into an unlocked cell, the formatting of the cell is overwritten with the formatting of the source. This has been observed on several versions of Excel, including XP, 2003, and 2007. The current environment requires that there be no macros, so are we stuck with this quirky paste behavior unless/until macros are allowed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros to copy and paste data | Excel Discussion (Misc queries) | |||
| Problem with copy and paste together with macros | Excel Worksheet Functions | |||
| Prevent changing size when copy&paste into another Excel Worksheet | Excel Worksheet Functions | |||
| Copy and Paste Macros | Excel Discussion (Misc queries) | |||
| prevent the copy and paste function | Excel Discussion (Misc queries) | |||
Threaded Mode
