I need a line of code so that when I hit commandbutton2, the Private Sub Worksheet_Change(ByVal Target As Range) event macro on the same page DOESN'T run. The button clears certain lines, and when it runs the change event it ends up in an error, and I don't need it to run when hitting the commandbutton. Thanks!
Last edited by jman0707; 11-15-2008 at 01:35 AM.
One option is to have the command button add text to a random cell when clicked (for example, add an "x" to cell Z1. Then you can add a test to the Worksheet_Change Event.
A quick example:
Please Login or Register to view this content.
Thanks! 2 quick questions. i've never had a button put text in a cell, what syntax does that use? And once I push the button, won't the text stay in the cell and then every time I change something in the worksheet it won't run the worksheet_change event? Or does it somehow test it, then I can get it to delete?
Then BigBas' code adjusts to watch AA1 as so:Please Login or Register to view this content.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
It can't be an off/on sort of thing, I need it the commandbutton to clear certain rows without triggering worksheet_change, then allow the worksheet_change event to be immediately active again. Here's what I put in the commandbutton code:
And this in the workshee_change event right in the beginning:Please Login or Register to view this content.
But it's still not quite working. Any ideas?Please Login or Register to view this content.
Last edited by jman0707; 11-15-2008 at 01:16 AM.
You haven't told us what you're deleting, so you'll have to edit the "clear" event in this code to delete what you want, but this commandbutton macro will work:
Please Login or Register to view this content.
Oh, Ok perfect! I think all I needed was the enableevents to be false so nothing else would run. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks