Excel Macro Message

[Melody]

I know this isn't an Access issue. I've posted it on the Excel page, which doesn't seem to get much traffic, so I thought maybe someone here might have an answer: Some time ago I was messing around with macros in a couple of my worksheets. I've since deleted them, but every time I open these worksheets, I get a message box asking me to either enable or disable the macros. I've gone to Tools-Macro-Macros and checked in This Workbook and All Workbooks. There are no macros in either of these worksheets. How do I get rid of this annoying message?

 

[RobMc]

I don't know if it's the case here, but there may well be a Macro in your Personal.xls workbook....I've come across this a few times.

 

[Jordan2000]

It is posible that there is just a private sub in 1 of the pages of module.
you can get rid of it by opening the VBA developer en look in the project. of the workbook that is generating the message,

 

[Idris]

It can be a workbook or a single worksheet or any customized Macro button on the toolbar linked to the macro or a part of References/Add Ins will trigger the message. Empty event will also trigger the confirmation message as it depends on what code is being about to be executed on openstatement. Recheck it just cannot perform on its own.