| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to only allow pasting of values and not format??
Thanks in advance for any help given!! I have a template spreadsheet that is formatted (ie. colors, numbe format, borders, etc). I want to be able to protect the format whil allowing the user to copy data into the cell....basically only allowin "paste values". I am pretty sure I need to use an "event change" macro, but I am no sure how exactly to say "if someone pastes something into m spreadsheet accept only the value (or restore all origina formatting)". any suggestions -- Cel ----------------------------------------------------------------------- Celt's Profile: http://www.excelforum.com/member.php...fo&userid=1941 View this thread: http://www.excelforum.com/showthread.php?threadid=52363 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting Values between sheets in VBA | Excel Worksheet Functions | |||
| pasting values | Excel Discussion (Misc queries) | |||
| Pasting Format and values | Excel Discussion (Misc queries) | |||
| pasting values | Excel Discussion (Misc queries) | |||
| Pasting numbers and formulas without pasting format. | Excel Discussion (Misc queries) | |||
![Celt[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
