Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get my macros from an XLA file to show in Tools Macro smartin Excel Worksheet Functions 0 June 28th 09 10:48 PM
Excel '00, 1st file has macros, how to stop macro in 2nd file? kaptandrews Excel Discussion (Misc queries) 0 May 24th 06 03:07 PM
how can i make macros to work when in tools, costumize and option. MOLECULA0_0 Excel Worksheet Functions 2 May 18th 06 04:54 AM
Macro Msg. when file has no macros Stilla Excel Worksheet Functions 2 February 9th 06 03:10 PM
How to stop file open macro prompt after deleting all macros? twor57 Excel Worksheet Functions 2 November 29th 05 05:00 PM


All times are GMT +1. The time now is 07:51 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"