Results 1 to 2 of 2

Thread: object rotation

  1. #1
    Lounger
    Join Date
    Feb 2009
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have several objects I want to rotate further away from the axis.
    In excel 2007, for 3-D rotation, under shape format there is a "Distance from Ground" entry.
    What is the macro command for "Distance from Ground"?
    i.e. Worksheets(1).Shapes ("Oval 27").???

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    [quote name='santford' post='766864' date='23-Mar-2009 14:19']I have several objects I want to rotate further away from the axis.
    In excel 2007, for 3-D rotation, under shape format there is a "Distance from Ground" entry.
    What is the macro command for "Distance from Ground"?
    i.e. Worksheets(1).Shapes ("Oval 27").???[/quote]

    I do not have Excel 2007, but you should have Excel record a Macro and put an entry in "distance from ground" in the Excel Workbook and then turn off Macro Recorder.

    Next view the VBA Code, it should supply the proper VBA code you will need.

    Regards,

    Tom Duthie

Posting Permissions

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