Disabling BeforeSave event

[bren1519]

I have no idea how the BeforeSave event was enabled on Excel, but everytime I try to save I get the prompts for the event no matter which Excel workbook I have open. How do I get rid of this event and can I disable it globally or must I change each workbook?

Thanks for the help!
Brenda

[Newsgroup]

use this

application.EnableEvents = FALSE


There must be code enabled in the ThisWorkbook excel object or you have a
class module that ties into the BeforeSave event. Caution this will disable
ALL EVENT code from executing. even in other workbooks. I would advise you
to find the code you are referring to and change it or delete it.


"bren1519" <[email protected]> wrote in
message news:[email protected]...
>
> I have no idea how the BeforeSave event was enabled on Excel, but
> everytime I try to save I get the prompts for the event no matter which
> Excel workbook I have open. How do I get rid of this event and can I
> disable it globally or must I change each workbook?
>
> Thanks for the help!
> Brenda
>
>
> --
> bren1519
> ------------------------------------------------------------------------
> bren1519's Profile:
http://www.excelforum.com/member.php...o&userid=33563
> View this thread: http://www.excelforum.com/showthread...hreadid=533486
>

[Bob Phillips]

Which prompts are you referring to?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bren1519" <[email protected]> wrote in
message news:[email protected]...
>
> I have no idea how the BeforeSave event was enabled on Excel, but
> everytime I try to save I get the prompts for the event no matter which
> Excel workbook I have open. How do I get rid of this event and can I
> disable it globally or must I change each workbook?
>
> Thanks for the help!
> Brenda
>
>
> --
> bren1519
> ------------------------------------------------------------------------
> bren1519's Profile:
http://www.excelforum.com/member.php...o&userid=33563
> View this thread: http://www.excelforum.com/showthread...hreadid=533486
>