Prev: command buttons disappear when I move worksheet 2007
Next: data lookup
From: Joe M. on 25 Jan 2010 15:14
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.
From: Lucas B on 25 Jan 2010 19:41
Change the Macros In option from All Open Workbooks to This Workbook and that
should fix it.

"Joe M." wrote:

> 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.
 | 
Pages: 1
Prev: command buttons disappear when I move worksheet 2007
Next: data lookup