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
copy cell based on date 4
Conditional Format Based on Date 3
How do I change contents of a cell based on drop down list selecte 2
Reference the same cell based on tab name 1
turn a cel a color based o todays date 9
projecting time and date from hours entered 1
Return the current Yearly Quarter based on date 2

Top