Consulting

Results 1 to 2 of 2

Thread: Size with Chart property of format picture in VBA

  1. #1

    Post Size with Chart property of format picture in VBA

    Does anybody know how to control "Size with Chart" property of format picture in VBA?

  2. #2
    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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •