Events, dear boy, events

  • Thread starter Thread starter Gromit
  • Start date Start date
G

Gromit

Aha

I pasted:

Application.EnableEvents = true

into the immediate window and now the code is working. I don't have an
code that would have turned it off in the first place, however. Coul
this be a default setting somewhere, or is just one of those thing
that can happen now and then?

Anyway, thanks for the solution, Bo
 
Just a guess.

If you turn it off in code (and you're stepping through the code while it's
executing), you may have ended your routine before the .enableevents = true was
run.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command button to toggle worksheet event code on / off? 15
Date Stamp with protection 6
Static Now() function 7
Events, dear boy, events 1
Worksheet Change Event macro fails intermittently 6
Worksheet Change event not firing but Worksheet activate event does 1
How to preserve current selection after appl.events carry out an copy-pastespecial action ? 1
VBA 10

Back
Top