Consulting

Results 1 to 9 of 9

Thread: Macro not running

  1. #1
    VBAX Regular
    Joined
    Aug 2009
    Posts
    7
    Location

    Macro not running

    Hello,
    I have one simple macro that is not running when the graphic is clicked in presentation mode (nothing happens upon click). The action settings for the graphic are set to "Run macro" and its name. Macros are enabled, and the code is simply:

    Sub asub()
        Dim a As Integer
        a = 25
        MsgBox "a=" & a
    End Sub
    The macro runs when I select Tools --> Macros --> Run macro

    Any thoughts? Thanks so much!

  2. #2
    VBAX Regular
    Joined
    Aug 2009
    Posts
    7
    Location
    Anyone have any ideas? I am clueless as to why nothing happens when I click the image in presentation mode.

  3. #3
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,729
    Location
    Works fine for me in PP 2010
    Attached Images Attached Images
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,729
    Location
    Delete the .zip part since .pptm files can't be uploaded for some reason
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  5. #5
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    As of today, PPTM files may now be uploaded
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  6. #6
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    When you mouse over the graphic in show mode does the cursor change to the hand icon?
    John Wilson
    Microsoft PowerPoint MVP
    Amazing Free PowerPoint Tutorials
    http://www.pptalchemy.co.uk/powerpoi...tutorials.html

  7. #7
    VBAX Regular
    Joined
    Aug 2009
    Posts
    7
    Location
    John -
    Yes, I do get the hand icon, but nothing happens upon click. This is still a mystery. I can get it to work initially, but then if I save it in .pptm format, close the file and reopen it, it no longer functions.

    By the way, I'm using PowerPoint for Mac 2011.

    Thanks so much,
    Paul
    Last edited by palex; 05-09-2015 at 05:11 AM.

  8. #8
    VBAX Regular
    Joined
    Aug 2009
    Posts
    7
    Location
    Solved it... The problem was that there was an exclamation point in the filename!

  9. #9
    VBAX Master
    Joined
    Feb 2007
    Posts
    2,094
    Location
    I should have spotted that. It also applies to PC files and I had seen it before but forgotten that the ! has a special meaning in vba.
    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
  •