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.
|