View Single Post
  #2   Report Post  
Vacation's Over
 
Posts: n/a
Default 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!