On opening a worksheet move focus to a cell based on date

D

davcas

I would like to set focus on a cell row based on the date the worksheet is
being opended as I am running a team diary for holidays etc and each time it
is opened you have to scroll to find todays date in a column to look forward.
I do have a cell showin todays date for reference. Can anybody help with
this. Does it need an open macro or VB etc?
 
N

Nayab

I would like to set focus on a cell row based on the date the worksheet is
being opended as I am running a team diary for holidays etc and each timeit
is opened you have to scroll to find todays date in a column to look forward.
I do have a cell showin todays date for reference.  Can anybody help with
this. Does it need an open macro or VB etc?
Click to expand...

u can put the macro in auto_open module and it will automatically
execute on opening of the excel file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Focus on a cell based on date 3
Cell data entering slow! 0
Word macro that can call cells out of Excel for a find and replace 0
Color a cell based on column date and row content 2
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Goto Cell With Today's Or Other Date 2
Populate Cell with another cell, but only if the date equals today 4
Hide columns based on row values 2

Top