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. |
All times are GMT +1. The time now is 08:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com