Auto highlight on startup

[superdonk]

Hi guys

I've had a blank and need a hand with some coding...

I have a spreadsheet which, in essence, is a calendar of dates...

I'm after a code that will - on opening the wkbook - automatically highlight the row that matches todays date.

I no i'll have a cell with =today() an link the source code into that...i just cant think what the code will be?!

Help!

TVM

[RHCPgergo]

Hey superdonk,

if the cell is always the same, you just need this (let's say it's cell A1 on a worksheet named "MyWorkSheet"):

Please Login or Register  to view this content.

Make sure you put it in the ThisWorkbook module in the code window.

[martindwilson]

why not conditional format the cells , say dates are in col a starting a1 and you want the row that matches todays date which happens to be in a20
select a1 conditional format as formula option =$a1=today() copy cf across and down