Display only certain cells

[Guest]

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!

 

[Guest]

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 ???

 

[Guest]

I'm probably considered a beginner to intermediate user in Excel, with
Functions & VBA being a big weak spot, so please bear with me. The calendar
is very simple - each day has a formula which references the cell before it
(or the Saturday before) plus one. I have all the months lined up
horizontally on the spreadsheet (I wish I could send it to you) - I initially
did this so that when I double-click on it in the Word document, I could just
scroll over until the correct 3 months were displayed, then click out of it.
Also, I'm not sure what you mean by onscreen / Print Zoom. Thanks so much
for your help!