+ Reply to Thread
Results 1 to 5 of 5

Double Click not working properly

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Luxembourg
    MS-Off Ver
    Excel 2010
    Posts
    2

    Double Click not working properly

    Hi there,

    I wrote a program which is executing a macro after double-clicking on a cells.
    Problem is that nevertheless the double click Subroutine works fine most of the
    time, sometimes it simply stops working and instead it starts editing cells mode.
    Then I need to restart the Excel to make it work fine again.

    Do somebody know why it's making these issues please?

    Many thanks for any suggestions,

    Michal

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

    Re: Double Click not working properly

    Post the code.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Luxembourg
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Double Click not working properly

    Thanks John, the problem is, that I am changing the cells quite often, so I want the macro to execute
    in some "more special" event then changing or clicking on the cell. I don't want to involve the buttons
    (my boss don't want) and except the double-click I don't see any other option (maybe if you would
    know about something).

    Sorry ProtonLeah, the code is:


    Please Login or Register  to view this content.

    The problem is that sometimes (from unknown reason), after double-click it wants to edit cells
    and then I need to restart the Excel to make it work fine again. Is it the Excel bug or I'm doing
    something wrong?

    ???

    Thanks again for your help.
    Last edited by Cutter; 08-23-2012 at 11:21 AM. Reason: Added code tags

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Double Click not working properly

    @ MCertik

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

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

    Re: Double Click not working properly

    Well! That's only part of the code.
    However:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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