Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ringersoll
 
Posts: n/a
Default Display only certain cells

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!
  #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!

  #3   Report Post  
ringersoll
 
Posts: n/a
Default Display only certain cells

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!

"Vacation's Over" wrote:

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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i protect cells in a shared worksheet Debi Excel Discussion (Misc queries) 3 September 30th 05 11:15 PM
Cells formated as text do not always display properly Cass Excel Discussion (Misc queries) 2 July 23rd 05 01:59 AM
Display empty cells botany_girl Excel Discussion (Misc queries) 7 July 19th 05 06:40 PM
Display empty cells botany_girl Excel Discussion (Misc queries) 1 July 19th 05 05:51 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 12:47 AM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"