MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can I globalize a macro?


Posted by Brian Hurwitz on March 24, 2000 11:07 AM

I want to be able to use a function that converts
numbers into text (checktext) in a new spreadsheet or
any spreadsheet, without having to copy and paste the
VB code. Is that possible? I tried using personal.xls
and had no luck. Thanks in advance.


Posted by Ivan Moala on March 27, 2000 3:33 AM


Try using the format;
='D:\Xl_Useful\MyFile.xls'!MyFunc(mycriteria)

Where Myfile.xls = your file path with the function
MyFunc = yourfunction name
Mycriteria = your func criteria as it is.

Ivan

Posted by n/a on March 27, 2000 8:18 PM

Try saving your function code as an XL add in. The format should have an extension of XLA. You should be able to use your function in any workbook after saving and activating the add in.

Post a follow up and let me know if this works for you...