Create a monthly calendar
|
|
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
|
|
|