macro disabled permanently

[Cagdas Ozgenc]

Greetings,

I interrupted a macro I wrote that went into infinite loop by hitting
ESC. I fixed the macro function which is tied to "Worksheet_Change".
Now it never gets triggered. I put break points in code; not executed
at all. I close/open excel and respond to security dialog as "enable
macros", still not working.

I don't know what happened but code never gets executed. I don't know
what happened.

Help appreciated,

Cagdas Ozgenc

 

[Bob Phillips]

Sounds like events have been disabled.

Type

Application.EnableEvents = True

in the VBIDE immediate window.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)