+ Reply to Thread
Results 1 to 5 of 5

Trouble with the 'worksheet_selectionchange' event

  1. #1
    Registered User
    Join Date
    06-01-2014
    Location
    Arizona
    MS-Off Ver
    2007
    Posts
    17

    Trouble with the 'worksheet_selectionchange' event

    I run a macro that sorts the sheet at the end
    Apparently that kicks off a worksheet_selectionchange
    Event… I just want it to stop after my macro

    Thank you

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Trouble with the 'worksheet_selectionchange' event

    Hi,

    Stating the obvious I suppose but why not just delete the worksheet selection change event. Your use of the word apparently suggests the selection change event is not something you want.

    However if a selection change event is relevant try introducing an
    Please Login or Register  to view this content.
    before your code and finish with an
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    06-01-2014
    Location
    Arizona
    MS-Off Ver
    2007
    Posts
    17

    Re: Trouble with the 'worksheet_selectionchange' event

    I am making a little program that when you touch the screen a menu appears (I'm using the selection change)
    The Macro runs on the same sheet but it's something else
    But the debugger shows me that I'm running both

    The application.events idea sounds like it will work, but I don't have it
    Do I need to enable a reference or something? Get a newer version of excel?

    Thank you for helping me

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Trouble with the 'worksheet_selectionchange' event

    Just a typo. Both should be Application.EnableEvents
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Trouble with the 'worksheet_selectionchange' event

    Indeed so. Mea culpa. Thanks for the correction shg.

+ 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. Event Procedure - Worksheet_SelectionChange
    By sakmsb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-30-2014, 09:36 AM
  2. [SOLVED] Worksheet_SelectionChange Event to Run Public Sub MyMacro
    By KarlaM in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 04:50 PM
  3. Differentiate keypresses in Worksheet_SelectionChange event
    By Mervil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2010, 03:59 AM
  4. Using Worksheet_SelectionChange() event macro
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-27-2007, 05:32 PM
  5. Worksheet_selectionchange Event
    By Alex Mackenzie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2005, 12:05 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