Hi Michael
I was attempting to create 2 additional "default" options on the "Edit"
toolbar, one for pasting values and one for pasting formulae - in both cases
leaving the formatting of the destination cells unchanged. It should be as
simple as using the usual Excel default of "Edit>Paste" which, as you know,
copies everything.
Am I missing something or have I misunderstood you?
--
XL2002
Regards
William
(e-mail address removed)
| On Thu, 6 Jan 2005 07:53:34 -0000, "William" <
[email protected]>
| wrote:
|
| >Hi Michael
| >Here is one possibility...
| >
| >Copy the sub below into the ThisWorkbook module of your Personal.xls
file.
| >The code creates 2 new options on your "Edit" menu to copy the selected
| >range as values or formulae.
| snip...
|
| William,
|
| First, thank you for taking the time to assist.
| However, if I understand your suggestion, I'm still forced to _make a
| choice_ of how information is pasted. I already have a mechanism to
| use if I want to make a choice not to paste the original cell's
| formatting; I can use the "paste special" option and choose "values"
| or "formulas".
|
| Now, I'm a marketing guy, not an excel head, so you already know I'm
| not the brightest bulb in the chandelier, but it seems _ludicrous_ to
| me that if I want to paste _only_ the information from one cell to
| another and always keep the destination cell's formatting in tact,
| there isn't a _default_ option within the options menu to allow me to
| set the paste _default_ to paste _only_ the information (whatever it
| is-- value or formula), leaving the destination cell's formatting
| alone. (???)
|
| Gawd I hope I'm missing something simple here...
|
| Thanks again,
| Michael