View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Kilmer[_2_] Bob Kilmer[_2_] is offline
external usenet poster
 
Posts: 71
Default How to put excel macros in a 'global' place.

An addin can be made to work if you learn all the necessary steps. I don't
know them off the top of my head, but the easiest thing to do is put them in
your Personal.xls workbook

"Peter van de Kerkhof" wrote in message
...
Hi,

I wrote some excel macros that need to be stored in a 'global place'
accessable from multiple workbooks.
I put them in an .xls, created an .xla and put that in the addin list,

but
I can't call the included public defined macros.
(I want to call the macros using a workbook button!)

How to solve this?
or
What is a better solution?

Regards Peter
--