Exposing a function to other workbooks

  • Thread starter Thread starter Ameritech
  • Start date Start date
A

Ameritech

I have a VBA function defined in a module of one workbook. I'd like it to be
accessible to other workbooks open at the same time. Ideally, I'd like to do
this in such a manner that the other workbooks - whether opened before or
after the one containing the function - don't require any user actions in
order to access the function.

Is this possible? If so, how? (For reasons not worth going into, I'd like to
avoid taking the "add-in" route.)
 
Just put the function in your PERSONAL.XLS. This will make
it available as long as you have Excel open!

Nikos
 
Back
Top