Posted to microsoft.public.excel.programming

[email protected] ucanalways@gmail.com is offline

external usenet poster

Posts: 115

ActiveSheet.Shapes macro

ActiveSheet.Shapes("Chart 18").ScaleWidth 1.99, msoFalse,
msoScaleFromTopLeft
ActiveSheet.Shapes("Chart 19").ScaleWidth 1.99, msoFalse,
msoScaleFromTopLeft

Instead of having a macro like this, I am looking for a macro that
will resize the chart to its scalewidth irrespective of the chart
name.

Something like, resize all shapes in a particular sheet to a
scalewidth like 1.99 or any other value.. Can anyone throw light on
this please?

Thanks

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
activesheet.shapes("Group 1...n")	Andreww	Excel Programming	1	May 18th 07 11:14 AM
Copying new activesheet after other activesheet is hidden?	Simon Lloyd[_790_]	Excel Programming	1	June 20th 06 10:02 AM
ActiveSheet.Shapes	ole_	Excel Programming	1	April 26th 05 02:34 PM
ActiveSheet in a Macro?	Randy S[_4_]	Excel Programming	3	February 1st 05 02:19 PM
Shapes In ActiveSheet	Tommi[_2_]	Excel Programming	5	December 2nd 03 02:02 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us