Run macro when worksheet opens

[Ham]

I want to run a VBA routine attached to a worksheet whenever that worksheet is displayed. How can I do this?

Thanks. -- Ham

 

[rmikesmith]

Ham,

Use the OnActivate event for the worksheet. To do this, open the VBA Editor. Select the worksheet in the Project window then click the view code button. Select Worksheet from the left dropdown then Activate from the right. The editor will write the event procedure shell. Just add your VBA code here. It will run each time the specified worksheet is activated.


Regards,
M. Smith

 

[Ham]

Works like a charm. Thank you very much. -- Ham