How do I get my macros from an XLA file to show in Tools > Macro

  • Thread starter Thread starter MikeS
  • Start date Start date
M

MikeS

I've created an XLA file that I plan on sharing with co-workers (it
will be on the network)

I have put some Sub macro code in the XLA and saved them.

But those macros don't show up when I go to Tools > Macro

What is the "best practice" when it comes to this?

I've read about creating a toolbar in the XLA. Is this what I need to
do?
 
MikeS said:
I've created an XLA file that I plan on sharing with co-workers (it
will be on the network)

I have put some Sub macro code in the XLA and saved them.

But those macros don't show up when I go to Tools > Macro

What is the "best practice" when it comes to this?

I've read about creating a toolbar in the XLA.  Is this what I need to
do?
Click to expand...

Your options are adding a custom toolbar or adding a submenu under the
Tools menu in the worksheet menu bar. Usually best to add a custom
toolbar. I guess the reason Excel doesn't make Subs in add-ins visible
is because the Excel developers believe that if you know enough to
write XLAs, you should know how to create toolbars as well.
 
Back
Top