I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm
trying to do is copy and paste numbers from a statistics table online into my
open workbook. Now I can enable and disable the "paste options" button that
appears when I paste the number. from the button the options are to "Keep
source formatting" or "Match Destination Formatting". The default is to "keep
source formatting" and that wont show up in the workbook correctly. What I
want to know is can I change any options so that no matter what I copy and
paste it will match the formatting of my workbook by default and give me the
choice to keep source formatting as an option instead of vis-versa.

Charlie

You cannot add to the smart tags options or alter the default. At least
through the User Interface or VBA

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"Charlie B" <Charlie wrote in message
...
I'm using Microsoft Excell 2003 from Office 2003 Professional. What I'm
trying to do is copy and paste numbers from a statistics table online into
my
open workbook. Now I can enable and disable the "paste options" button
that
appears when I paste the number. from the button the options are to "Keep
source formatting" or "Match Destination Formatting". The default is to
"keep
source formatting" and that wont show up in the workbook correctly. What I
want to know is can I change any options so that no matter what I copy and
paste it will match the formatting of my workbook by default and give me
the
choice to keep source formatting as an option instead of vis-versa.