*Resolved* OnSheet_Selection?

[TheRobster]

Is there a VBA command (in Excel) that will run a procedure located in a sheet when that sheet is activated? I was thinking of something along the lines of the Selection_Change command but instead of having to change the focus on the sheet, I want the procedure to run when that sheet is selected.

I was rather hoping that Excel would keep a track of all the procedures in a sheet so that if the conditions of the sheet change and one of the procedures says 'do something if a cell value = a certain number' then that change would automatically occur, but it seems that I have to call the procedure to make it work. I can get it to work by attaching it to a Forms button but I want it to run whenever that sheet is selected and not only if I change the focus or press a button!

Any ideas?

Cheers
-Rob