Macro Still There?

Ellio

Board Regular
Joined
Apr 9, 2008
Messages
51
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?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Ellio

Board Regular
Joined
Apr 9, 2008
Messages
51
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

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,270
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

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Also Named ranges can refer to Excel 4 macros..
Insert - Name - Define
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,982
Messages
5,834,686
Members
430,310
Latest member
Excelorate3305

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top