Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > ms office 100% is too small?

ms office 100% is too small?
Thread Tools
Senior User
Join Date: Oct 2001
Status: Offline
Reply With Quote
Dec 28, 2004, 08:10 PM
 
shouldnt 100% zoom for word documents be the actual print size? i ask because on my windows computer 100% is the actual size i'll get.

on my powerbook, when i set the view to 100% the text is very small. I have to crank it up to 125% to get it viewable.

1.) is there a reason or a way to fix this?

2.) if not.... how do I make 125% the defualt view size?

thanks in advance
     
Dedicated MacNNer
Join Date: Jun 2000
Status: Offline
Reply With Quote
Dec 28, 2004, 08:22 PM
 
With MS Word 2004, open a new blank document, select the 125% Zoom, then close that document, and open a new blank document. It should be at the 125%. Then quit Word, and reopen with a new blank document - it should also open at 125%. I just went through this a few minutes ago and it worked perfectly.

MS Excel 2004, however, does not retain the zoom. The way around this is to have a macro for AutoOpen that would zoom to the proper %.
Ignore the argumentative nature of this poster. He is old and can't engage in meaningful dialog
very long. Therefore, management asks that you at least humor him. Thanks.
     
Mac Elite
Join Date: Jan 2001
Status: Offline
Reply With Quote
Dec 28, 2004, 08:26 PM
 
As for #1) '100%' relies on the (now old school) theory that computer monitors are all set at 72dpi. Newer monitors have much higher resolutions, thus making 100% documents look smaller on screen than they print. Just use higher magnification.
     
reemas  (op)
Senior User
Join Date: Oct 2001
Status: Offline
Reply With Quote
Dec 28, 2004, 08:27 PM
 
thanks, the tip on word worked fine!

is there a reason 100% isn't quite 100%?
     
reemas  (op)
Senior User
Join Date: Oct 2001
Status: Offline
Reply With Quote
Dec 28, 2004, 08:28 PM
 
we posted at the same time purplegiant, so thanks for the info..
     
Professional Poster
Join Date: Mar 2002
Location: Boston
Status: Offline
Reply With Quote
Dec 29, 2004, 06:14 AM
 
I hate that with the office apps, I need to use 125 or beyond. Sometimes, I'll set the font to be larger or keeping the zoom up at 125 - 150. I then email that spreadsheet or document, talk about huge on pc.

Mike
     
Dedicated MacNNer
Join Date: Jun 2000
Status: Offline
Reply With Quote
Dec 29, 2004, 06:42 PM
 
I mentioned code that you could use for AutoOpen. However, given your situation about interaction with pc/windows versions of Excel, that wouldn't be good.. But you could write code that would set the zoom for 125%, and then another piece of code to reset the zoom to 100%. You could assing to a button on the toolbar and it would always be handy.

By separating the two (rather than toggle) this gives the flexibility to keep it at your desired zoom but instanteously change it before mailing.
Ignore the argumentative nature of this poster. He is old and can't engage in meaningful dialog
very long. Therefore, management asks that you at least humor him. Thanks.
     
Dedicated MacNNer
Join Date: Jun 2000
Status: Offline
Reply With Quote
Dec 29, 2004, 07:01 PM
 
Here are the two pieces of code.

Code:
Sub Zoom125() ActiveWindow.Zoom = 125 End Sub Sub Zoom100() ActiveWindow.Zoom = 100 End Sub
To use these, hit OPTION + F11, which opens the VBE window. On the left side, you will see the Project Explorer window. You should have a folder named VBA Project (Personal Macro Workbook). Click the arrow beside the Module folder (under the Project). Click the Module folder and go to the menu Insert > Module. In the window that appears on the right, paste this code into it.

Check it out by going back to Excel itself, and with a new Excel document open, go to Tools > Macro > Macros. This will bring up a window with the macros listed on the left side. Select the Zoom125, and click Run. The zoom should change appropriately.

To assign this to a button for handy use, go to View > Toolbars > Customize toolbars. In the window, select the Commands tab, on the left side scroll down to Macros, select it. On the right side you will see two options. Click and drag "Custom menu item" to any toolbar, then release the mouse button (a drak vertical line will appear when you can release the button). Then CTRL + Click that button, and choose "Assign macro", and a dialog box appears with the macros - choose Macro125. Click OK. Then CTRL + Click the button again and change it's name to something like Zoom125. Click OK, and OK.

Try the button. If it works, then repeat the process with the other macro, Zoom100.

After you finish, quit Excel. It will ask if you want to save changes to Personal Macro Workbook. Be sure to click "Yes" - or you will have to do the entire procedure all over again.

HTH. (If you need help establishing a Personal Macro Workbook, just ask)
Ignore the argumentative nature of this poster. He is old and can't engage in meaningful dialog
very long. Therefore, management asks that you at least humor him. Thanks.
     
   
Thread Tools
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Top
Privacy Policy
All times are GMT -5. The time now is 06:22 AM.
All contents of these forums © 1995-2011 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.7 © 2000-2011, Jelsoft Enterprises Ltd., Content Relevant URLs by vBSEO 3.3.2