Incorrect macro message

[Ron Macy]

I have been using a particular workbook which has no
macros associated with it. I have another workbook which
does have macros. Somehow, the workbood without macros has
an indicator associated with it which causes the
Disable/Enable Macro message box to display. Where might
such an indicator be? I would like to turn it off so I
don't get the misleading message box any more.

Thanks,
Ron

 

[Frank Kabel]

Hi Ron
there're probably some empty modules in your workbook. Try the
following:
- open the VBA editor
- delete/remove all (empty) modules
- check the worksheet modules and the workbook module
- cloese the VBA editor and save your workbook
- try again

 

[Gord Dibben]

Ron

Possibly a left-over empty module.

See Debra Dalgleish's site for info and removal instructions.

http://www.contextures.on.ca/xlfaqMac.html#NoMacros

Gord Dibben Excel MVP