Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Word / July 2009



Tip: Looking for answers? Try searching our database.

Create a monthly calendar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
chickieram@officeformac.com - 02 Jul 2009 18:47 GMT
Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

How do you create a monthly calendar that you can input data in each day?
CyberTaz - 02 Jul 2009 19:21 GMT
Start looking here. Any of the templates for Word 2003/4 or prior & many of
those for 2007/8 should be usable. Keep in mind that Word is not the only
[nor perhaps the best] program for calendars.

http://office.microsoft.com/en-us/templates/CT101043131033.aspx?av=ZWD

If you decide to use any of the templates you should also look at the info
here:  http://word.mvps.org/mac/Using-Windows-Templates.html

Have you considered the Calendar capabilities of Entourage?

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 7/2/09 1:47 PM, in article 59b77741.-1@webcrossing.caR9absDaxw,

> Version: 2004
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Intel
>
> How do you create a monthly calendar that you can input data in each day?
John McGhie - 03 Jul 2009 11:22 GMT
Bob is correct (as usual!) Word is not a good weapon for calendars.

Microsoft does not want to offer "real" templates that make calendars,
because that would cut across "sales" of other products.

However, I made one in Excel that you can simply download.

It's in Excel 2008, so you will also need the Office 2008 Converter from the
Mactopia site if you do not already have it.

The Calendar is here:
http://public.jgmcghie.fastmail.com.au/Calendar.xlsx

You don't. Of course, have to keep the colours and decorations: they're just
from one of the Microsoft templates.  The active bit is simply the Excel
formulas, which can be copied and pasted into any design of your choosing.

Hope this helps

On 3/07/09 3:47 AM, in article 59b77741.-1@webcrossing.caR9absDaxw,

> Version: 2004
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Intel
>
> How do you create a monthly calendar that you can input data in each day?

Signature

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group.  Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia.   mailto:john@mcghie.name

Phillip Jones, C.E.T. - 03 Jul 2009 20:46 GMT
here's one I have that I had with help with Bob Greenblatt (shows up
frequently in excel newsgroup.

http://www.phillipmjones.net/AutomaticCalendar.xlsx

Note its formatted to be a Desk calender. That folds out from back and
sits like a small Picture.  It even accounts for leap year. All that
needs changing from year to year is in January change the year from 2009
to 2010 and change next time to 2011 and so on the days automatically
shift according to year given.

I'm quite sure the width's and Heights could be adjusted to make a full
size calendar

> Bob is correct (as usual!) Word is not a good weapon for calendars.
>
[quoted text clipped - 22 lines]
>>
>> How do you create a monthly calendar that you can input data in each day?

Signature

Phillip M. Jones, C.E.T.  "If it Ain't Broke, Don't Fix it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com

Phillip Jones, C.E.T. - 03 Jul 2009 22:12 GMT
Rather than using separate sheets. I formatted the page for landscape.
Then I sized in such a way that it uses another page (sheet of paper)
there are two moth to a page.

If you can figure out how to break the months into separate pages,  or
even separate sheets of a workbook, without breaking formulas that would
be great.

> here's one I have that I had with help with Bob Greenblatt (shows up
> frequently in excel newsgroup.
[quoted text clipped - 40 lines]
>>> How do you create a monthly calendar that you can input data in each
>>> day?

Signature

Phillip M. Jones, C.E.T.  "If it Ain't Broke, Don't Fix it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com

John McGhie - 03 Jul 2009 23:49 GMT
Hi Phillip:

That's a BEAUTIFUL website you have there!  I am deeply impressed :-)

However, I couldn't get your Calendar link: Safari confuses XLSX with XML,
which means all I get is word-salad when I try to download it.  Which
browser are you using?

Cheers

> here's one I have that I had with help with Bob Greenblatt (shows up
> frequently in excel newsgroup.
[quoted text clipped - 36 lines]
>>>
>>> How do you create a monthly calendar that you can input data in each day?

Signature

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group.  Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia.   mailto:john@mcghie.name

Phillip Jones, C.E.T. - 04 Jul 2009 13:39 GMT
SeaMonkey.

 if you click on the link and hold you should get something to the
effect of Save Link target.

In SeaMonkey you don't even Have to ask a screen will come up with
choices of open with then you choose application or save to disk.

If I made a zip of it would it work better?

> Hi Phillip:
>
[quoted text clipped - 46 lines]
>>>>
>>>> How do you create a monthly calendar that you can input data in each day?

Signature

Phillip M. Jones, C.E.T.  "If it Ain't Broke, Don't Fix it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com

Phillip Jones, C.E.T. - 04 Jul 2009 13:52 GMT
Try this <http://www.phillipmjones.net/Calendar.zip>

This time I have both xls and xlsx version in the zip.

You don't try to open directly, you try to download.

> Hi Phillip:
>
[quoted text clipped - 46 lines]
>>>>
>>>> How do you create a monthly calendar that you can input data in each day?

Signature

Phillip M. Jones, C.E.T.  "If it Ain't Broke, Don't Fix it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com

Michel Bintener - 04 Jul 2009 17:56 GMT
I'm using Safari 4 under Mac OS X 10.5.7, and I can download the file
without any problem. When I click the link in Phillip's message, Safari
opens a new window and starts downloading the file immediately.

On 04/07/09 0:49, in article C674C808.1FE1C%john@mcghie.name, "John McGhie"
<john@mcghie.name> wrote:

> However, I couldn't get your Calendar link: Safari confuses XLSX with XML,
> which means all I get is word-salad when I try to download it.  Which
> browser are you using?

Signature

Michel Bintener
Microsoft MVP - Macintosh

*** Please always reply to the newsgroup. ***

John McGhie - 05 Jul 2009 00:26 GMT
Hmmm...  Now that I am using Safari 3 under Mac OS 10.5.7, I can also get
Phillip's original link.

Curious...  The MacBook doesn't like the link, the MacPro does...

Oh well, I have other issues to fiddle with :-)

Cheers

On 5/07/09 2:56 AM, in article C675566F.10D69%mbintener@NOmvpsSPAM.org,

> I'm using Safari 4 under Mac OS X 10.5.7, and I can download the file
> without any problem. When I click the link in Phillip's message, Safari
[quoted text clipped - 6 lines]
>> which means all I get is word-salad when I try to download it.  Which
>> browser are you using?

Signature

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group.  Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia.   mailto:john@mcghie.name

Phillip Jones, C.E.T. - 05 Jul 2009 03:52 GMT
After you look at the calendar,
 I was asked by email how someone could add an item on a date like a
meeting .

Could they use insert comment.

On a spreadsheet I am using to keep up with my mother's bills
temporarily I added some comments some items. Could they do that . for
what they need?

> Hmmm...  Now that I am using Safari 3 under Mac OS 10.5.7, I can also get
> Phillip's original link.
[quoted text clipped - 17 lines]
>>> which means all I get is word-salad when I try to download it.  Which
>>> browser are you using?

Signature

Phillip M. Jones, C.E.T.  "If it Ain't Broke, Don't Fix it"
http://www.phillipmjones.net           http://www.vpea.org
mailto:pjones1@kimbanet.com

John McGhie - 05 Jul 2009 13:00 GMT
Hi Phillip:

Yeah, he could do that, but it would be easier to insert a row beneath each
row of numbers.

Then Protect the cells with the date formats in them.

That way, they are typing in blank cells.

However, if that's what they want to do, they're starting to get to the
point where it would be better to use Entourage and use a real Calendar.

Cheers

On 5/07/09 12:52 PM, in article e8Sr2uR$JHA.1252@TK2MSFTNGP04.phx.gbl,

> After you look at the calendar,
>   I was asked by email how someone could add an item on a date like a
[quoted text clipped - 27 lines]
>>>> which means all I get is word-salad when I try to download it.  Which
>>>> browser are you using?

Signature

Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group.  Please do NOT email me unless I ask you to.

John McGhie, Microsoft MVP, Word and Word:Mac
Sydney, Australia.   mailto:john@mcghie.name

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.