Thread: Sub add-ain
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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!