ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Alt + F8 (https://www.excelbanter.com/excel-programming/362123-alt-f8.html)

Mike Archer

Alt + F8
 
Hello - When I bring up a list of macros in a workbook of mine, all of the
macros are listed with their short name. One, however is listed with the
name of the workbook, the name of the module, and the name of the macro..
Like this:

DeliciousLister.xls!GetCategories.GetCategories

That macro is part of the workbook that is open... and it is the only
workbook that is open. What causes that, and how do I fix it?
--
Thanks,
Mike

Chip Pearson

Alt + F8
 
If you have duplicate named macros you will see the behavior you
describe. Ensure that all macros have unique names.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mike Archer" wrote in
message
...
Hello - When I bring up a list of macros in a workbook of mine,
all of the
macros are listed with their short name. One, however is
listed with the
name of the workbook, the name of the module, and the name of
the macro..
Like this:

DeliciousLister.xls!GetCategories.GetCategories

That macro is part of the workbook that is open... and it is
the only
workbook that is open. What causes that, and how do I fix it?
--
Thanks,
Mike





All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com