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
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
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.
Thank you I will do that and let you know how it worked out for me.
-Brian
Don’t have an account yet? Register yourself now and be a part of our community!