Hello all!

Well, as you'll notice I'm a newbbie in Excel, but have some stron
programming knowledge.
So, what I'm trying to do, is this:

Have an Excel sheet with days of the month (1 month per sheet in th
workbook), on 1,2,3,4... cells I have the dates of the month, and the
A, B, C, D ... are my header (it is for hours reporting). What I woul
like to do, is that each time that the user opens the spreadsheet
current date is highlighted. So, in some way I want the program t
recognize we're (e.g.) in july, and that he finds 06, and the
highlihts it. Something like:

LOOP AT "A"
IF system_date = selected_cell
set highlight_cell
endif
endloop



Well, this is how I see it, but how is it feasable trough VBA...?


Thanks! :cool

--
Message posted from http://www.ExcelForum.com