Paste Button default option

[Michael McKenney]

When the paste button is turned on and an item is copied/pasted, the
little paste button pops up. Then I can right click on it and choose an
option. The "default" option is "keep source formating." Is there a
way to make the options always to be set at "match destination formatting"?

I know that an item cut and pasted can easily be changed by clicking the
paste button and then clicking "match destination formatting," but it
would be easier/quicker if somehow I could change the default to "match
destination formatting" and thus eliminate the need to ever have to
click the paste button and then choose the "match destination" button.

Thanks for any help, and I apologize ahead of time if this issue has
already been discussed/answered here.

Mike from Milwaukee

 

[DA]

Hi Michael

I'm not aware of an option setting that can specify your
paste format. You can however intercept the paste event
and specify macro code that pastes in the format you
require.

Insert a new module into Normal.dot and place the
following Sub into it.