Display only certain cells
How is your Calendar set up in Excel?
Could use conditional formatting and =month(now()) <=month(Now()) to black
out other months
Or if you use VBA could hide rows & columns using the above arguments in the
Workbook_Open Event
How complex do you need?
Do you want onscreen / Print Zoom ???
"ringersoll" wrote:
I have an assignment to create a Timeline document with a calendar that
displays only the current month & the 2 months following. I started with a
Word document, pasted into it a calendar I made in Excel, then adjusted the
object boundaries to only display the 3 months. Is there a function that
will cause the calendar to automatically display the current & 2 months
following? I'm so lost!
|