Display 'Paste Options' smart tag via VBA


Posted by Aron on January 23, 2002 7:17 PM

I have an add-in that will copy the sum of the selected cells on a sheet, and then paste the sum only in the desired cell. I'd like to give the user of matching either the source or destination formatting, if possible, e.g. by enabling the paste options smarttag (XP) or something similar. Any ideas?

Thanks in advance,
Aron



Posted by Aron on January 23, 2002 7:19 PM

...when not actually using the 'paste' function/command...