Consulting

Results 1 to 20 of 20

Thread: Solved: Anyone have a "What Am I" macro?

  1. #1
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location

    Question Solved: Anyone have a "What Am I" macro?

    I know this is a shot in the dark, but before I wonder down the dark alley ways of Powerpoint VBA, and try to write my own ...

    I was wondering is any one had a "What Am I" macro ... which I'm thinking would be a command button or shortcut key macro that would provide context specific information about whatever the selection was.

    So is a shape was selected, the macro would popup a form with information about the shape: X, Y, L, W, fill, border, name (!!!), etc.

    Same for slides, placeholders, etc.

    I have one for Excel but the Excel object model is a lot easier to understand

    Here's hoping

    Paul

  2. #2
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    not exactly but close.
    Should get you started.

    John
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  3. #3
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Hey guys,

    There's a great addon that I discovered here:
    http://www.pptools.com/index.html

    Specifically the SHAPESTYLES and STARTERSET PLUS downloads. He has created some useful stuff! One of them being a button that tells you everything about a selected object. (it's the pig icon on the StarterSet Plus download)

    [EDIT] -- I paid for the full verison, so I'm not sure if the free version lets you use all of the features, but it's very cheap and I think it's worth it.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    I'm a cheapie! I can confirm the pig is in the StarterSet, and works the same.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    TrippyTom - John --

    Good starting point -- thanks

    Paul

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    John,

    A question for you, seeing as you are a PPT MVP.

    How do you exactly create a PPT addin to allow application events, and how do you look at code in a loaded addin?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  7. #7
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Most addins have passworded code. If not you can modify the registry to view them.
    HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\PowerPoint\Options
    Create or change DWORD "DebugAddins" value = 1.
    (If this means nothing to you don't go there!)

    Event handling is not simple. There'a fairly simple example in the Kbase on this site. Just as an aside the example is unnecessary as you can create a simple switch in the shortcut to do the same thing! If you have a particular event in mind we can easily create a template for the add in (not free but cheap!)
    john AT technologytrish.co.uk
    Last edited by Aussiebear; 04-28-2023 at 02:04 AM. Reason: Adjusted the code tags
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  8. #8
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Do you have the URL for that KBase entry handy?

    Thanks for the registry key, that helps.

    As someone who provides tons of support for free, I am not into paying for it myself, even cheap <G>
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  9. #9
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  10. #10
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Hey John,
    I set that registry, and opened an add-in that I wrote (no password on it) and I'm still not seeing the code. Do I have to do something special to see it?
    Office 2010, Windows 7
    goal: to learn the most efficient way

  11. #11
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    LOL! I assumed that you meant the MS KBase, no wonder I couldn't find it.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  12. #12
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    If you havent got 2003 you need to change the 11 to the version number.

    Here a shot of my reg
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  13. #13
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Oh, I think my problem was I forgot to close PPT before making the change. When I went back to the value, it was still set at "0".

    OOPS!
    It's fixed now, thanks.

    This helps a lot, because now I don't have to save a separate PPT version anymore just to see the code!
    Office 2010, Windows 7
    goal: to learn the most efficient way

  14. #14
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    Hmm, now I'm confused again.

    When I make changes to a form in an add-in and save changes, the change is not showing up when I reinstall the addin. How do you ensure the .ppa file has the most recent changes if you're editing the .ppa file directly?

    [EDIT] -- it's not just form edits.. it's code too. So it must be opening an old version of the file somehow when I reinstall? Man this is confusing.
    Last edited by TrippyTom; 08-22-2007 at 02:16 PM.
    Office 2010, Windows 7
    goal: to learn the most efficient way

  15. #15
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Edits to addins don't "stick"!! You can just view them. It is possible to export forms , modules etc and import them into the original powerpoint but basically you need to work on the ppt file.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  16. #16
    VBAX Expert TrippyTom's Avatar
    Joined
    Jul 2005
    Location
    New York, NY (USA)
    Posts
    556
    Location
    bah!

    Well that's entirely useless to me then. I might as well change the registry back to the way it was. Thanks anyway. Stupid Microsoft.... grrr!
    Office 2010, Windows 7
    goal: to learn the most efficient way

  17. #17
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    Actually it's quite useful when you have an addin "nearly" working 100%. When a bug crops up you can quickly experiment with break points and minor changes. You'll still have to go back to ppt or export / import the modules / forms though for the final update.

    I think most professionals work in the ppt until its perfect.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  18. #18
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    John, even us non-professionals work in the PPT, but I'm still looking for perfection.

    Paul

  19. #19
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    PPT ... perfect. Isn't that an oxymoron.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  20. #20
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,093
    Location
    If you believe you have a foolproof system, you've failed to take into consideration the creativity of fools.
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

Posting Permissions

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