View Full Version : Size with Chart property of format picture in VBA
jaywang2000
11-08-2018, 07:12 PM
Does anybody know how to control "Size with Chart" property of format picture in VBA?
jaywang2000
11-12-2018, 01:42 AM
I found the solution after some trials.
ActiveChart.Shapes.Range(Array("chart")).Select
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.Placement = xlMoveAndSize 'xlFreeFloating: Do not size with chart. 'xlMoveAndSize: Size with Chart
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.