VBA used to resize objects?

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 37

VBA used to resize objects?

i am trying to resize all objects on a sheet. is there a way to assign a
variable, all the objects, rather then using the code below?

'resize charts
--- ActiveSheet.Shapes.Range(Array(4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20)).Select

Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Width = 173.25
Selection.ShapeRange.Height = 102#

Thanks for your help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Embedded Excel Objects in PowerPoint resize after editing	Barb Reinhardt	Excel Discussion (Misc queries)	0	September 21st 09 06:41 PM
How do resize objects (charts) in Excel to precise specs?	Confused Charter	Charts and Charting in Excel	2	April 5th 07 10:36 PM
I could NOT resize the axis title but excel allows me to resize gr	Iwan Setiyono Ko	Charts and Charting in Excel	4	June 6th 06 04:46 AM
I could NOT resize the axis title but excel allows me to resize gr	Iwan Setiyono Ko	Charts and Charting in Excel	0	March 15th 06 10:34 AM
Why can't I resize/move objects in XL XP chart?	tjak	Excel Discussion (Misc queries)	5	March 7th 05 02:13 PM

All times are GMT +1. The time now is 04:38 AM.

Menu

About Us