Macro message

[Adrae]

I have various workbooks that were built by somebody else. Everytime I open one of them, I am asked to enable or disable the macros. As far as I can tell though, there are no macros. I don't want to disable the message because I do actually want to know when a workbook contains macros before enabling them.

The workbooks are relatively large, as workbooks go (6M each).

How can I find out why this message box occurs?

Thanks Adrae

 

[Al Chara]

Hit Alt+F11 to open VBA. Then look to the left for the project explorer and click around to see if there are any macros.

If there aren't any then in the project explorer look for the folder that says "Modules" and double click it. Then right click on each subfile and select "Remove..." and hit "No" to not export. Then save and reopen and you should not get the enable macros box anymore.

 

[Jack in the UK]

Hi --

try in VB editor clicking on the worksheets them self in case target entry has been added if not ment, very common will repoet as macro even thou not doing a thing.. check all sheets.

 

[Adrae]

Some sheet have the following:

Option Explicit

Is it alright to delete this?

Thanks Adrae

 

[Mark O'Brien]

If that is the only line of code on the sheets then, yes. If those are the only lines of code it should also get rid of the macro warning message.

Actually, if that wasn't the only line of code you could delete this anyway. It's only used to make sure programmer's declare all of their variables. But that's beside the point.

_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-04-16 12:21

 

[Jack in the UK]

Yes delete all the data.. you clearly say NO MACROS delete the, BUT check ALL sheets..

then save and close

re open no warning as no macros should be the result...