LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Macro list in Tools - Macro

I checked for that but it was not the case. I have since remedied the problem
by renaming the macros. They all started with "StorePr" followed bt a 4
letter code e.g StorePrAMXZ. When I renamed them to test1, test2 etc it
solved the problem. As did StorePr_AMXZ. If I change the name back to StorePr
followed by the 4 letter code I once again get the module name preceding the
macro name. It's a mystery but it doesn't matter now. I can only think that
maybe Store is a reserved word and should not be used as a prefix to a macro
name.
Thanks for replying.

"excelent" wrote:

think u got 2 macros with same name

"Ben" skrev:

When I select Tools - Macro from any worksheet it displays a list of the
macros in the workbook. I am curious to know why some macros in my list , all
in a particular module have the name of the module preceding the macro name.
e.g "Module3.MyMacro" rather than just "MyMacro" . In all the other 20 or so
macros I have in a variety of other modules, the name of the module does not
appear. Everything runs ok but is it hiding a potential problem.
Thank you

 
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
Macro not showing up/missing under TOOLSMACRO or VBE Rubin Farr Excel Programming 2 October 19th 06 09:11 PM
disable user running macro from Tools Macro Steve Simons Excel Discussion (Misc queries) 4 September 28th 06 06:28 AM
Macros in personal.xls not all showing up in Tools|Macro List zharrisonremoveatgmail.com Excel Programming 1 August 16th 05 09: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


All times are GMT +1. The time now is 07:05 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"