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