![]() |
|
|
|
#1
|
||||
|
||||
|
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] |
|
#2
|
|||
|
|||
|
Thank you for taking your time informing me regarding this, I will investigate with your alternatives, as they seem to provide a better solution to my problems.
Thanks again! |
|
| Tags |
| macro, resize objects, resize pictures |
|
|
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 |
Resize multiple PowerPoint objects in a table at the same time
|
Duradel | Word Tables | 3 | 11-16-2014 04:01 PM |
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 |