Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to run another macro?
i have a complexed macro for sheet activate programmed but yet want the same macro to fire within another event it would be highly impractical to simply cut and paste the code to another point within vba so is there a code to trigger this event even though the sheet is already activated? i.e run.macro_worksheet active() thanks in advance any help much apprechiated -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=386611 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to run another macro?
Change the sub declaration from private to public and you can call it like
any other procedure. Just make sure you reference the call with the sheet. -- HTH... Jim Thomlinson "short_n_curly" wrote: i have a complexed macro for sheet activate programmed but yet want the same macro to fire within another event it would be highly impractical to simply cut and paste the code to another point within vba so is there a code to trigger this event even though the sheet is already activated? i.e run.macro_worksheet active() thanks in advance any help much apprechiated -- short_n_curly ------------------------------------------------------------------------ short_n_curly's Profile: http://www.excelforum.com/member.php...o&userid=21576 View this thread: http://www.excelforum.com/showthread...hreadid=386611 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting code from a macro (by a macro) | Excel Discussion (Misc queries) | |||
Macro copying macro code | Excel Programming | |||
Macro to change Macro code? | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |