+ Reply to Thread
Results 1 to 4 of 4

run a macro when a user double-clicks on certain columns on an excel table

  1. #1
    Registered User
    Join Date
    12-29-2012
    Location
    Latakia, Syria
    MS-Off Ver
    Excel 2010
    Posts
    61

    run a macro when a user double-clicks on certain columns on an excel table

    Hi all,
    I have a table, named "gloss.". I also have a macro called "summon Mendeley" that I wish to run when I double-click on columns 4, 5, 7, 9 and 11 of "gloss.". I don't want that macro to fire whenever I double click anywhere else on the sheet nor the table! I am new to excel, yet I have the impression that should be easily done! still, I couldn't get it to work!
    here is the code I have now
    Please Login or Register  to view this content.
    could you, please, help me to adjust it so it can be useful for my work?
    any help will be super appreciated!

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: run a macro when a user double-clicks on certain columns on an excel table

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: run a macro when a user double-clicks on certain columns on an excel table

    You didn't state which column your table starts in so the above might not be 100% correct. Also, did you mean double-clicking the columns headers or is it anywhere in the column. If it's just the header row then:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  4. #4
    Registered User
    Join Date
    12-29-2012
    Location
    Latakia, Syria
    MS-Off Ver
    Excel 2010
    Posts
    61

    Re: run a macro when a user double-clicks on certain columns on an excel table

    thanks a lot! it really worked!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Execute code when user double clicks on any cell within a range of cells
    By Jenn68 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-11-2019, 11:34 AM
  2. Macro that double clicks a cell
    By Bredsida in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-15-2016, 05:37 AM
  3. Improving code to hide Rows when user double clicks in column A
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2012, 02:10 AM
  4. If User Double Clicks on Cell in Column
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2012, 11:54 PM
  5. Run a macro when a user clicks in a certain cell
    By NickySA in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2007, 08:20 AM
  6. Activate a Pop Up Calendar Every Time a User Double Clicks in Column A or C
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2005, 09:05 PM
  7. [SOLVED] unable to open Excel file by double clicks
    By Renyan in forum Excel General
    Replies: 2
    Last Post: 01-15-2005, 10:06 PM

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