Running a Macro
When developing and testing a macro I usually want to be viewing the
worksheet as the macro runs. So I use Alt-F8 to bring up the macro listing. But I have a silly problem. The worksheet name is a long one, and so the entire worksheet/macro name stretches beyond the window to the right. There is no way to identify the individual macros. Sometimes it seems like just the nice short macro name appears in the Macro list window. Other times the "full path" is shown, including the worksheet name. Why is this? |
Running a Macro
If you have multiple workbooks open, it will add the workbook name to macros
in workbooks other than the active workbook. -- __________________________________ HTH Bob "ArthurJ" wrote in message ... When developing and testing a macro I usually want to be viewing the worksheet as the macro runs. So I use Alt-F8 to bring up the macro listing. But I have a silly problem. The worksheet name is a long one, and so the entire worksheet/macro name stretches beyond the window to the right. There is no way to identify the individual macros. Sometimes it seems like just the nice short macro name appears in the Macro list window. Other times the "full path" is shown, including the worksheet name. Why is this? |
Running a Macro
"Bob Phillips" wrote: If you have multiple workbooks open, it will add the workbook name to macros in workbooks other than the active workbook. -- Thanks Bob. That was it. __________________________________ HTH Bob "ArthurJ" wrote in message ... When developing and testing a macro I usually want to be viewing the worksheet as the macro runs. So I use Alt-F8 to bring up the macro listing. But I have a silly problem. The worksheet name is a long one, and so the entire worksheet/macro name stretches beyond the window to the right. There is no way to identify the individual macros. Sometimes it seems like just the nice short macro name appears in the Macro list window. Other times the "full path" is shown, including the worksheet name. Why is this? |
All times are GMT +1. The time now is 08:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com