View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default How do I get my macros from an XLA file to show in Tools Macro

MikeS wrote...
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?


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.