MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to convert macro to add in


Posted by Anis on March 03, 2000 11:40 AM

Hi

I have created a personal macro, which I would like to give it to few people. How would I convert this macro to an addin.

Q if the user who I am giving it to is a bigginer in excel. How would I make it easy for him so he can call it with few click of a button.

Q what is .xla and how is it used. how do you convert macro into .xla file.


Posted by bill.roberts on March 07, 2000 7:50 AM

Anis,

I know this isn't what you want BUT, I too am interested in your question and hopefully this might at least point you in the right direction.

http://support.microsoft.com/support/kb/articles/Q156/9/43.asp

BUT WAIT!!!! HERE'S THE BEEF!!!!

http://support.microsoft.com/support/kb/articles/Q156/9/42.ASP