excel/vba message

[andrej]

Hi everybody, I have a problem that I cannot solve myself. When I am trying to save my bot that contains vba code I get a message that I have never seen before.

Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web contents. These may include personal information that cannot be removed by the document inspector.

this would be just fine but the preblem is that this message pops up even when running the bot (approx once in 10 minutes) and stops the VBA code from running until I click OK or cancel. It never happened to me before (all the other bots I have been running did not force this message to popup)

does anybody know how to get rid of this?

thank you

[osknows]

Perhaps this may work in Excel 2007 & 2010

Options > Trust Center > Privacy Options > Document-specific settings > Deselect "Remove personal information from file properties on save"

or possibly in your VBA code enter

Application.Displayalerts = FALSE at the start of your code and
Application.Displayalerts = TRUE at the end

[andrej]

Thank you osknows, puttin Application.EnableEvents = false/true did not work
(I have put it in every sub begining/end) but the trust center setting seem to work.
once again thank you

[osknows]

puttin Application.EnableEvents = false/true did not work
(I have put it in every sub begining/end)once again thank you

Not Application.EnableEvents = false/true

Application.Displayalerts = false/true

[andrej]

I have actually used Application.Displayalerts = false/true
I do not know where I have the .enableevents copied from. sorry