Sub add-ain
Arne,
If it is a function in the add-in, you should be able to call it directly,
like
=MySpaceRemover(A1)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Arne Hegefors" wrote in message
...
Hi! I have a very easy sub that I use for deleting blank spaces between
thousand numbers (ie 1 000 000 becomes 1000000). I use this sub for many
workbooks. I have reated an add-in that contains this sub and loaded it.
But
I dont know how to run the sub. Usually I just press alt + F8 and I get
the
list of macros avaliable. but this does not come up even if i loaded the
add-in. My question is is add-ins just for functions or how can I run my
sub?
I know you can do it by automaically launching the sub when a workbook is
opened but that wont do t for me (sine I paste data to the worksheet and
then
I have to run the sub). Please help me solve this. Thanks alot!
|