+ Reply to Thread
Results 1 to 6 of 6

Using Worksheet_BeforeDoubleClick

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Using Worksheet_BeforeDoubleClick

    Greetings,
    I am using the following code and all works great. However, I have 2 rows on worksheet "A" and 1 row on worksheet "B" that I do not want for the user to choose. In other words, on WS-"A", rows 1 and 2 have instructions, and starting with row 3 the cells can be chosen - the same princilpe with WS-"B".
    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    08-27-2019
    Location
    Alabama, USA
    MS-Off Ver
    365, 2016, 2010, 2007
    Posts
    57

    Re: Using Worksheet_BeforeDoubleClick

    Following, as I would also like to see an elegant way of doing this.

    You could try the following if you don't get any better replies:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Using Worksheet_BeforeDoubleClick

    Hi there,

    Your post doesn't make clear whether you wish to protect those rows from ALL User interactions or just the DoubleClick action, but the title of your post suggests the latter.

    Inserting the following code in the "ThisWorkbook" VBA CodeModule will disable the DoubleClick action on the worksheets and rows which you specified:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  4. #4
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Using Worksheet_BeforeDoubleClick

    spencer and Greg,
    Thank you both for your suggestions. I tried both and they do "lock" rows 1 & 2 on sheet "A" and "B". However, the cells that contain the DoubleClick action are still able to access by double-clicking.

  5. #5
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: Using Worksheet_BeforeDoubleClick

    All,
    I figured it out. mt_CM_who Range is set to access only the cells within the column.
    Please Login or Register  to view this content.
    Last edited by brentjohn; 09-28-2019 at 12:30 PM.

  6. #6
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Using Worksheet_BeforeDoubleClick

    Hi again,

    Many thanks for your feedback - glad to hear that things are working correctly for you now.

    Regards,

    Greg M

+ 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] Worksheet_BeforeDoubleClick = Multiple Ranges
    By terratushi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2017, 06:49 AM
  2. [SOLVED] Worksheet_BeforeDoubleClick (allow if cell is numeric)
    By terratushi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2017, 03:56 PM
  3. [SOLVED] Rename help please for. Private Sub Worksheet_BeforeDoubleClick
    By A440 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-15-2017, 10:03 AM
  4. [SOLVED] Sub Worksheet_BeforeDoubleClick
    By ana.ciofrangeanu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-24-2014, 10:31 AM
  5. Worksheet_BeforeDoubleClick Not Working
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2014, 06:50 AM
  6. Ambiguous name detected: Worksheet_BeforeDoubleClick
    By ConfusedaboutVBA in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 08:44 PM
  7. [SOLVED] Sub Worksheet_BeforeDoubleClick from elsewhere?
    By Jack Sons in forum Excel General
    Replies: 2
    Last Post: 11-02-2005, 06:17 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