+ Reply to Thread
Results 1 to 5 of 5

Link macro to a cell (not an object) in Excel 2007

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Link macro to a cell (not an object) in Excel 2007

    I would like to link a macro to a specific cell (rather than an object) in Excel 2007. When you click on that cell, I would like the macro to run. Is this possible?

  2. #2
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Link macro to a cell (not an object) in Excel 2007

    max67,

    In the appropriate sheet code module:
    Please Login or Register  to view this content.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-07-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Link macro to a cell (not an object) in Excel 2007

    If VB is the only option (and I'm not the best with VB), can you provide additional detail? I'd like to click on cell G1 and then run the macro I've named "Filter2012".

  4. #4
    Forum Guru tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Link macro to a cell (not an object) in Excel 2007

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-07-2012
    Location
    NJ
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Link macro to a cell (not an object) in Excel 2007

    That worked perfectly. Thank you!

+ 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