Disabling BeforeSave event
 

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

Disabling BeforeSave event
 

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" wrote in
message ...

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

Disabling BeforeSave event
 

Which prompts are you referring to?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"bren1519" wrote in
message ...

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