Create and navigate a sheet for every day

[jondallimore]

Afternoon,

Can anyone point me in the right direction for this:

I need to have a worksheet for every school day in the year - this is easy enough to do using some VBA I already have.

However, I then want to create a master sheet with a command button that will take me to the relevant worksheet for today.

OR - even better... some code that will take me to todays worksheet automatically when the sheet first opens.

Any suggestions?
Thanks
Jon

 

[Lee.]

Private Sub Workbook_Open()
zsheet = Format(Date, "DD.MM.YYYY")
Sheets(zsheet).Select
End Sub

Change DD.MM.YYYY to the format which you have saved the date in

 

[jondallimore]

Legend. Thankyou.
I was thinking it was much more complicated than that!