Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Know Last Run Macro
Hi All,
Is there any coding that could tell what the last macro that have been run from a Workbook(Workbook1)? I want to know that macro's name so I can run same macro that have similar name in other Workbook (Workbook2). Please help me, really need that. Thanks, Resant |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Know Last Run Macro
Last macro in the current session or last macro period?
You would have to include code in (or a call from) each of your macros which saved the macro name somewhere (name, range, global variable, etc) Tim "Resant" wrote in message ups.com... Hi All, Is there any coding that could tell what the last macro that have been run from a Workbook(Workbook1)? I want to know that macro's name so I can run same macro that have similar name in other Workbook (Workbook2). Please help me, really need that. Thanks, Resant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Know Last Run Macro
I've thought that, but there's many macros I've created, it will
consumed many time. I was wondering is there the code that could show last macro that have been ran by user. Any other solution please? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |