LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel,alt.comp.lang.vba,microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Macros in personal.xls not all showing up in Tools|Macro List

Hi all-

I have a bunch of macros defined in multiple macros in my personal.xls.
They are all defined with "Sub", none of them are public or private.
However, only some of them show up in the listbox if I goto
Tools|Macro. If i manually type in:

PERSONAL.XLS!<macro name,

then the Run button un-graysout and excel recognizes it.

How can I get all of my macros to show up in the listbox?

Thanks

zach

 
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 Harlan Grove[_2_] Excel Worksheet Functions 0 June 28th 09 11:34 PM
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
Show Macro list (tools-macro-macros) Hafeez Esmail Excel Programming 5 December 31st 03 09:54 PM
Macros not appearing in the Tools Macro Macros list hglamy[_2_] Excel Programming 5 October 24th 03 09:10 AM
List the Macros that can be executed from Tools-Macros Rob Bovey Excel Programming 1 July 10th 03 05:34 PM


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

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

About Us

"It's about Microsoft Excel"