auto starting macro's

briaNRDonohue · Jun 17th 2003

I was wondering if there is a way to record a macro on to a sheet then have it automaticly start whenever you go to that sheet.

-Brian

**royUK** · Jun 17th 2003

Right click on the sheet tab and select View Code
Make sure WorkSheet is selected in the left dropdown and then find Activate in the right hand drop down . Put your code here to run when the sheet opens.

briaNRDonohue · Jun 17th 2003

Thank you I will do that and let you know how it worked out for me.

-Brian

auto starting macro's

Participate now!

Share