Calling a public Macro from a Private Macro
ActiveWorkbook is the active workbook. ThisWorkbook is the workbook that
holds the macro that is running. Does that help? Otto
"thewizz" wrote in message
...
Yet another question!!!
I am trying to use the Worksheet_change Event to call a macro that I have
placed in the "ThisWorkbook" folder using Application.run. The problem I
am
having is that I do not want to use the specific name of the workbook in
the
statement because it can change since I am making a "Template". Any
suggestions how I can call the Active workbook instead?!?! I have tried
several itterations and nothing seems to work. I keep getting application
failure. I assume it cannot find the macro....
Example:
Worksheet name - myworksheet
macro name - runme
Application.run "'myworksheet.xls'!ThisWorkbook.runme"
but replace "myworksheet.xls" with a generic statement
Thank you!
--
I am not where I intended to go, but I think I am where I am supposed to
be!
|