Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get my macros from an XLA file to show in Tools Macro | Excel Worksheet Functions | |||
Excel '00, 1st file has macros, how to stop macro in 2nd file? | Excel Discussion (Misc queries) | |||
how can i make macros to work when in tools, costumize and option. | Excel Worksheet Functions | |||
Macro Msg. when file has no macros | Excel Worksheet Functions | |||
How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions |