Posted to microsoft.public.excel.misc

EagleOne@microsoftdiscussiongroups[_2_] is offline

external usenet poster

Posts: 7

Cannot get VBA to Change PageSetup.FitToPagesWide = 1

2003

The following commands work fine:

ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.O rientation = xlPortrait
ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.O rientation = xlLandscape

The next commands do not "bomb" but that do not change the PageSetup as
listed.
ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.F itToPagesWide = 1
ActiveWorkbook.Worksheets("STARS_UMD").PageSetup.F itToPagesTall = 1

I must go to the PageSetup wizard, make the change from 50% to 1 and 1.

Any thoughts and VBA changes helpful.

TIA EagleOne

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PageSetup Macro	Julian Glass	Excel Worksheet Functions	1	March 29th 08 01:54 PM
Chart PageSetup Size Speed VBA	Brian Reilly, MVP	Charts and Charting in Excel	4	January 9th 07 04:06 AM
PageSetup	Stanley	Excel Discussion (Misc queries)	1	December 14th 05 07:21 PM
Why is this PageSetup Macro So Slow?	[email protected]	Excel Discussion (Misc queries)	6	July 19th 05 09:28 PM
PageSetup.LeftFooter only on last Page	Andy	Excel Worksheet Functions	3	December 6th 04 01:53 PM

All times are GMT +1. The time now is 10:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us