Strange Macro name problem

  • Thread starter Thread starter Joe M.
  • Start date Start date
J

Joe M.

When I go to TOOLS > MACRO > MACROS, all the macro names now appear with the
workbook name plus a module # proceeding the macro name like this below:

Sched vs CLSD with Costs 2009-12 w FY10 WBS_FIX CHART.xls'!Module6.Clear_data

Now I can't even see the macro names unless I click on it and move the
cursor to the right! What happened? Is there a way to stop this from
happening again. And can I re-name the macros back to what they were? I don't
see any place to edit the name. HELP!!!

Thanks,
Joe M.
 
Change the Macros In option from All Open Workbooks to This Workbook and that
should fix it.
 
Change the Macros In option from All Open Workbooks to This Workbook and that
should fix it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to hide worksheet based upon text in the name 5
Macro deletion 1
Macro to hide sheets based upon cell value 3
HELP! Record Macro in TOOLS > MACRO is gone! 3
Macro problem after copying an Excel File 5
Workbook name in VBA doesn't match filename.xls 5
Delete macro that is not in a module 5
Microsoft Word 2017 VBA Troubleshooting Restart Numbering Macro 0

Back
Top