Excel 2007 VBA - Shapes (Enhanced Features)

Posted on 2009-12-29
Last Modified: 2012-05-08
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.
Question by:Marts
    LVL 85

    Accepted Solution

    That's a pretty vague question, but MSDN is a good place to start. For example:

    Author Closing Comment

    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.
    LVL 85

    Expert Comment

    by:Rory Archibald
    If you get the 2010 Beta, the recorder does work there, so that can be useful too! ;)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now