| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a public Macro from a Private Macro
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference between a private sub and a public function? | Excel Discussion (Misc queries) | |||
| Calling a private macro | Excel Programming | |||
| Calling a private sub | Excel Programming | |||
| public but private variables | Excel Programming | |||
| Public subroutine called from a private sub | Excel Programming | |||
Threaded Mode
