+ Reply to Thread
Results 1 to 4 of 4

Run macro when Image is clicked

  1. #1
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Run macro when Image is clicked

    Hi Guys,

    I have an excel workbook which I plan to use as a dashboard menu. This menu contains several PNG image files, each image file represents the particular macro to run.

    How do I run a macro when a particular Image is selected.

    Please see my attached workbook.

    If someone could please provide me with a snippet of Hello World code on how to do this that would be great!

    Regards
    Jordan
    Attached Files Attached Files
    Last edited by jordan2322; 03-18-2013 at 07:52 PM.

  2. #2
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    163

    Re: Run macro when Image is clicked

    Right click on the image and assign a macro (or whatever it is called - I don't have english ver. of Excel)

  3. #3
    Forum Contributor
    Join Date
    11-16-2011
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    405

    Re: Run macro when Image is clicked

    ha. too easy! thanks Sbarro79

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Run macro when Image is clicked

    Please Login or Register  to view this content.
    right click image assign macro "test"
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1