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.
Err unless it's changed recently it should be as simple as putting it into the "open" event
SteveCode:Private Sub Workbook_Open() Run "MyHighlightyMacro" End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)