Code for when a worksheet opens 1

[craiogram]

I've tried searching for this topic with no avail.
Is there a way to have code fire when a worksheet opens and where can I put it.
I have a macro that changes the color of some fields based on the value of another but I don't want to have to click anything for it to happen.

Thank you much in advance,
Al

 

[ClulessChris]

Private Sub Workbook_Open()

End Sub


Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[bdmangum]

Select the desired sheet from the Project Explorer under the Microsoft Excel Objects folder and the navigate to the below default subroutine using the drop down menus above the work area.

Private Sub Worksheet_Activate()

End Sub

 

[SkipVought]

Hi,

"...when a worksheet opens..."

Do you mean, when a WORKBOOK opens or when a WORKSHEET activates?

The first two posts represent each of the above, respectively.

Skip,
[sub]
Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference![/sub]