LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Macro name listing

Excel XP, Win XP
I have some 17 macros listed in my file under Tools - Macro - Macros. Of
those, 16 are listed with just their names, as in "MyMacro". The 17th one
insists on being listed with the full path:
'My File Name.xls'!MyModuleName.MyMacroName

I tried commenting out that macro, saving the file, opening the file.
Listing is the same.
I tried copying the macro to Word, deleting the macro, saving the file,
closing Excel, opening Excel, opening the file, copying the macro from Word
back to the VBE, closing the file & Excel, opening both. Same listing.

Three questions:
Why is that macro listed that way?
Is there any significance that it's listed that way?
How do I get that macro listed with just the name?

Thanks for your help. Otto


 
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
Listing multiple values in a macro ToddS Excel Worksheet Functions 6 April 8th 09 03:53 PM
Factorial Listing Branson Excel Discussion (Misc queries) 3 June 6th 08 04:18 PM
Listing top three leaders Killer Excel Worksheet Functions 10 November 29th 06 10:37 PM
Directory listing Nigel Chapman Excel Discussion (Misc queries) 2 April 15th 05 02:52 PM
sum and listing Andreas5516 Excel Discussion (Misc queries) 2 February 4th 05 10:44 PM


All times are GMT +1. The time now is 09:54 AM.

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"