Size of a Excel 2001 sheet in Excel X

[Mike]

A bunch of our spreadsheets were created on OS 9 with Excel 2001. We
are now using OSX with Excel X. The files open up and work fine, but
when you print them they are about half the size on the page as they
should be. Even in print preview it's really small. The odd thing is
that when those spreadsheets are printed or previewed on an older
system with OS 9 and Excel 2001 they look and print fine. We know we
can increase the size to 200% before a print but we're wondering if
there's any sort of fix or update or setting we can use to get the
older files to print correctly on our new systems (I guarantee we'll
forget to increase the size often enough). Any ideas or experience
in this?
Thank you
Mike

 

[Jim Gordon MVP]

Hi Mike,

Check the settings in the Print dialog box that relate to your printer's
settings. Maybe the paper size is custom instead of regular.

-Jim

 

[Mike]

Hola. Well, I was able to change the page scale to 100% instead of
50% and it printed out fine. The problem is that this issue happens
with ALL our documents and unless we fix it for all of them (and there
are many) we'll still have the problem. Is there a way to change the
scale to 100% over all documents? I've checked the preferences but
haven't been able to find anything.
Thanx

 

[Mike]

Hi Mike,

Check the settings in the Print dialog box that relate to your printer's
settings. Maybe the paper size is custom instead of regular.

-Jim

Hola Jim. Well I changed the scale to 100% in the page setup and it
printed ok, but the problem is that we have 100's of these
spreadsheets that we use all the time and they're all gonna be messed
up and need to be changed. Is there anyway to make this change
universal so that ALL spreadsheets, no matter what, print at that
specific size? Like some sort of default settings change or whatever.
Thanx
Mike

 

[Jim Gordon MVP]

Hi

I think you will need a macro to automate the process. If you have not used
macros before, here's a link to get you started:

<http://support.microsoft.com/default.aspx?scid=/support/macexcel/content/Ma
cVBA/MacVBA.asp>

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

An Excel add-in is available to help with this task.
<http://www.rondebruin.nl/Google.htm>

----------