Thread: [Solved] Macro to resize all objects & pictures?
View Single Post
 
Old 01-18-2017, 02:37 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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