I don't know of any way to change the default. Too bad too, as I almost
always pick the target format.

--
Jim
"eggpap" wrote in message
...
|I have a certain formatting in my app. I'ld like to preserve it
| despite the user tasks of copying and pasting he can perform.
| I use Excel 2003 and it gives the ability to select the type of
| formatting to apply during a pasting operation:
| - apply the formatting of the source,
| - apply the formatting of the target,
| - values and numbers formatting etc.
|
| Excel applies the first of such choices as default.
|
| My question is this:
| may I get an initialization macro to set the second or the third
| of such choices as default choice?
|
| Emiliano
|
|