View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eggpap eggpap is offline
external usenet poster
 
Posts: 29
Default Applying the target formatting

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