Excel change data on open

[01hanstu]

Hi,

I am trying to create an excel sheet with lists of software and when it expires. Ideally when we open the sheet we want it to show the ones that expire within say a month it higlights the cell as red.

 

Cheers

- Stuart

[Steve21]

Err unless it's changed recently it should be as simple as putting it into the "open" event

 

aka:

 

Private Sub Workbook_Open()

Run "MyHighlightyMacro"

End Sub

 

Steve