Group:  Microsoft Excel ยป microsoft.public.excel
Thread: macro disabled permanently

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

macro disabled permanently
"Cagdas Ozgenc" <cagdas.ozgenc[ at ]gmail.com> 11.09.2006 08:18:12
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

Re: macro disabled permanently
"Bob Phillips" <bob.NGs[ at ]somewhere.com> 11.09.2006 08:44:07
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)

"Cagdas Ozgenc" <cagdas.ozgenc[ at ]gmail.com> wrote in message
news:1157962692.175931.168520[ at ]i42g2000cwa.googlegroups.com...
[Quoted Text]
> 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
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net