Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 02-01-2014, 09:00 PM
BobBridges's Avatar
BobBridges BobBridges is offline Formatting Macro based on Zoom (PageScale) Windows 7 64bit Formatting Macro based on Zoom (PageScale) Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Heck, if he wanted to increase Zoom until it was up to 40, all he'd have to do is say
Code:
 If .Zoom < 40 Then .Zoom = 40
(I speak under correction, because I've never done anything with Zoom in VBA.) I think he's saying that he wants to keep on adding pages until the zoom is at least 40%. I was staring at this earlier this evening — feeling sorry for him because none of us had answered him, I guess — and didn't know what to say because I don't know that adding pages (whatever that means) would affect the zoom.

In other words, he wants a loop like this:
Code:
Do While .Zoom < 40
  .FitToPagesWide = .FitToPagesWide + 1
  Loop
But would that affect the zoom? I don't know how that works.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Macro based on Zoom (PageScale) Word VBA Macro to Find and Replace based on the Alt Text of an Image bennymc Word VBA 1 01-27-2014 04:23 PM
MACRO - Insert row based on Form Field Criteria Elan05 Word VBA 5 04-16-2013 06:39 AM
Formatting Macro based on Zoom (PageScale) Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
Macro based on cell value ubns Excel Programming 1 05-07-2012 04:03 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft