• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 765
  • Last Modified:

Excel 2007 VBA - Shapes (Enhanced Features)

Is there a known way to manipulate the enhanced features of shapes using VBA, in MS Excel 2007? This would apply to the Right Click, Format Shape. Examples would be 3D, Gradient Stops, Bevel etc?

Any available references would be much appreciated. Thanks.
0
Marts
Asked:
Marts
  • 2
1 Solution
 
Rory ArchibaldCommented:
That's a pretty vague question, but MSDN is a good place to start. For example: http://msdn.microsoft.com/en-us/library/bb629413.aspx
Regards,
Rory
0
 
MartsAuthor Commented:
Thanks Rory. I didn't think of looking under 3D Animation. This looks like a good substitute for the missing shape properties under macro recorder.
0
 
Rory ArchibaldCommented:
If you get the 2010 Beta, the recorder does work there, so that can be useful too! ;)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now