xlPortrait in Macintosh

[Greg Lovern]

I have a macro that works fine on Windows for me but when another
person runs it on her Mac with Mac Excel 2001, it ignores xlPortrait
and the workbook it creates prints in Landscape. When she goes into
Page Setup for the workbook, it shows Landscape.

If I run the same macro and send her the file that the macro creates,
it prints in Portrait for her, and Page Setup shows Portrait.

I don't have a Mac, but as far as I can tell xlPortrait is valid on
Mac. I've tested this in Windows Excel 97, 2000, 2007, and 2010 and it
works fine on all of them.

Any ideas what the problem might be?


Thanks,

Greg

 

[ABS]

Greg,
Can she record macros with the Mac/Excel setup she has?
If yes, I'd want to see what it records when changing manually from
landscape to portrait, maybe there's a clue there.
If no, uh...dunno.
ABS