Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 01-18-2017, 02:37 PM
macropod's Avatar
macropod macropod is offline Macro to resize all objects & pictures? Windows 7 64bit Macro to resize all objects & pictures? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As I said previously, embedded & linked Excel objects do not have ScaleHeight and ScaleWidth values. Accordingly, you can't resize them using such an approach. The same applies to vector images and, AFAIK, embedded & linked OLE objects generally. Accordingly, if you want to constrain them to a particular size, you'd need to set the dimensions explicitly. An alternative approach would be to insert those objects into single-celled Word tables having a fixed height and width:
• For the rows, set the exact row height under Table Tools>Layout>Properties>Row>Specify Height>Exactly.
• For the columns, set the preferred column width under Table Tools>Layout>Properties>Columns and uncheck the 'automatically resize to fit contents' option under Table Tools>Layout>Properties>Table>Options.

However, if you're simply trying to prevent the unwanted resizing of linked objects:
1. Open the Registry Editor, then navigate to:
HKEY_CURRENT_USER\Software\Microsoft\Office\#\Exce l\Options
where # is your Office version number.
2. Add a new DWORD value: QFE_Boston
3. Set the new DWORD value to 1
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
macro, resize objects, resize pictures

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shift key not working to resize objects liambobrien PowerPoint 2 12-16-2015 11:03 AM
Macro to resize all objects & pictures? Resize multiple PowerPoint objects in a table at the same time Duradel Word Tables 3 11-16-2014 04:01 PM
Macro to resize all objects & pictures? Resize multiple pictures in a Word 2010 table JBA479 Word VBA 1 01-24-2014 08:51 PM
Resize and distribute width - 2 pictures AndyDDUK PowerPoint 2 10-10-2012 03:38 AM
Resize Email pictures in Outlook - Office 2007? jonesnewton Outlook 0 05-16-2010 04:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


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