Store makro code in Excel?

[Thomas Wieser]

Hi,

I wrote a makro which is accessed via a button in the menu bar. When I
click on it, Excel automatically starts up the Worksheet where the makro
is stored.

Is it possible to store the makro directly in Excel, so without calling
the xls file where it was written in?


Thanks in advance,

Thomas

 

[Frank Kabel]

Hi Thomas
you may put your macro in the psersonal.xls file. See
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Bob Phillips]

Hi Thomas,

No you can't do that, but you could create an addin, and install the addin
so that it is generally available, and not toed to a user workbook.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)