Disabling BeforeSave event

  • Thread starter Thread starter bren1519
  • Start date Start date
B

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
 
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.
 
Which prompts are you referring to?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top