Opening an Excel WB on a cell with todays date

[comboy]

Hi All,

I've got an Excel WB that is used as a diary for a number of trainers.
Each Sheet had been renamed to a month of the year and on each sheet B4 is the 1st of the month with the rest of the days in sequence down the coloum (Format 01-Jan-05).

What i need if possible is an autoexec macro that will set the focus on opening to the cell that contains the current date but I have no VBA experiance and cant find anything on the web so far that I could use or modify.

If anyone knows if this is possible and can point me in the right direction it will be very appreciated.

Thanks,

Graham

 

[xlbo]

1st - why have months on seperate sheets ??

2nd - keywords are:
workbook_OPEN event
Today()
the FIND method

combination of the 3 keywords above should get you started

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question

 

[comboy]

Hi Geoff,

Thanks for the reply I'll start looking at the keywords above.

Re seperate sheets: Was given the design and its to be stuck with no questions asked or suggestions given.

Graham.

 

[xlbo]

It will be MUCH easier to have ALL dates on 1 sheet

Any reporting from it will be easier and it will be easier to maintain

If this is not possible, you will also need to look at the FORMAT function to convert a date to a long month so you can compare to tab names eg:

testDate = today()
testMnth = format(testDate,"mmmm")
Sheets(testMnth).select

Rgds, Geoff

"Three things are certain: Death, taxes and lost data. Guess which has occurred"

Please read FAQ222-2244 before you ask a question