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
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
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
before your code and finish with anPlease Login or Register to view this content.
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.
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
Just a typo. Both should be Application.EnableEvents
Entia non sunt multiplicanda sine necessitate
Indeed so. Mea culpa. Thanks for the correction shg.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks