How can I make calendar open with current month, not January?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Rather than always opening with January and then having to scroll to current
month, can I do something to make calendar open with current month (and then
scroll up or down to earlier/later month, if necessary)? Present setup is
convenient only for January.
 
Rather than always opening with January and then having to scroll to current
month, can I do something to make calendar open with current month (and then
scroll up or down to earlier/later month, if necessary)? Present setup is
convenient only for January.

Put this macro in ThisDocument:

Sub AutoOpen()
Selection.Find.Execute FindText:=MonthName(Month(Now()))
End Sub
 

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

Back
Top