Macro Still There?

[Ellio]

Alright, So I've made this spreadsheet that contains 3 macros that automatically do a bunch of work for me, it works perfectly. My issue is that once the macro finishes doing all the work, I'm supposed to send the file to professors.

So I manually delete all the macro's (even going into the visual basic section and destroying all the modules, so there is NO trace of the macro left), and on a PC the spreadsheet opens fine, with no alerts about macro's (with all the work done and w/o macro's now), but on a mac it still gives a macro alert, I need that macro alert gone... What is the mac detecting that the PC is not? Any idea on how to fix this?

 

[Tom Urtis]

Delete the module(s) the macros were in.

 

[Ellio]

I've deleted all the modules, there are none left, yet it still gives the message on a mac, but not on a PC

 

[Tom Urtis]

Could be a custom command bar or something lingering from your code that is still in the interface...hard to diagnose without seeing the code you used and then deleted. Look carefully also at the object modules (workbook, sheet, class, etc).

 

[Jonmo1]

Also Named ranges can refer to Excel 4 macros..
Insert - Name - Define