OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Powerpoint (http://www.officefrustration.com/forumdisplay.php?f=17)
-   -   VBA resizing objects to same size (http://www.officefrustration.com/showthread.php?t=1125628)

Jakub Klein June 8th, 2011 01:32 PM

VBA resizing objects to same size
 
Hi folks,
this issue has been in my head for a while. Let s say you have several objects: A, B, C, D (no matter if pictures or classic objects) and you want to resize objects B, C, D to the size of object A including formating and such. I haven't been able to figure out the way to do that, I've seen it in my former employer Office 2003 customized version.
Thanks a lot for your help.
Jakub

tarquinious June 9th, 2011 08:57 AM

Quote:

Originally Posted by Jakub Klein (Post 3751094)
Hi folks,
this issue has been in my head for a while. Let s say you have several objects: A, B, C, D (no matter if pictures or classic objects) and you want to resize objects B, C, D to the size of object A including formating and such. I haven't been able to figure out the way to do that, I've seen it in my former employer Office 2003 customized version.
Thanks a lot for your help.
Jakub

The following is based on PowerPoint, but I suspect it will be the same for all MS Office products. As I can't find an automated method to do this, the manual method to do this is to:
  • Click on object A (that you want all other objects to be the same as)
  • Double-click the Format Paintbrush button on the Home button bar
  • Click once on each of the objects B, C, D, etc that you wish to take on this format
  • Click on the Format Paintbrush button again to turn off the formatting
  • Click once on Object A again and on the Format button bar, take note of the Height and Width values in the Size grouping
  • Now, holding down CTRL or Shift, select objects B, C, D, etc
  • Type in the Height and Width values you noted assigned to object A
Now, as I said, this is the manual way. I haven't seen a one-button solution to this in my travels, but can create one for you if you think this is something that will save you a lot of time and effort in the future.


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
OfficeFrustration.com