ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   running old xlm macro (https://www.excelbanter.com/excel-programming/377665-running-old-xlm-macro.html)

John Smith

running old xlm macro
 
How do I run the old xlm macro?

I have an old xlm macro which is auto open. I doulbe-click on the
..xlm file and the macro runs. It works fine.

How do I run the macro while the file is still open? I vaguely
remember in the old Excel there was a Run command in the
tools/macros. But the new Excel (2003, sp2) doesn't have such an
option. Thanks.

Jim Rech

running old xlm macro
 
the new Excel (2003, sp2) doesn't have such an option.

Tools, Macro, Macros still exists but only displays VB macros. You can type
in the macro's name though and it will run. You can also point to from the
Run dialog. Another option is to add a Forms toolbar button to a worksheet
and assign the macro to it.

--
Jim
"John Smith" wrote in message
...
How do I run the old xlm macro?

I have an old xlm macro which is auto open. I doulbe-click on the
.xlm file and the macro runs. It works fine.

How do I run the macro while the file is still open? I vaguely
remember in the old Excel there was a Run command in the
tools/macros. But the new Excel (2003, sp2) doesn't have such an
option. Thanks.




Tom Ogilvy

running old xlm macro
 
In xl2003,
Tools=Macro=Macros, has a run button, same as always.

--
Regards,
Tom Ogilvy



"John Smith" wrote in message
...
How do I run the old xlm macro?

I have an old xlm macro which is auto open. I doulbe-click on the
.xlm file and the macro runs. It works fine.

How do I run the macro while the file is still open? I vaguely
remember in the old Excel there was a Run command in the
tools/macros. But the new Excel (2003, sp2) doesn't have such an
option. Thanks.





All times are GMT +1. The time now is 03:40 AM.

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