MrExcel Publishing
Your One Stop for Excel Tips & Solutions

getting rid of activate macro message box

Posted by Marcus on April 04, 2001 12:57 AM


I have a workbook which is partly generated by macros. Before distributing this workbook I delete the macros.
But when opening the now macro free workbook I still get the annoying "This workbook contains macros, do you want to activate?" message.

Why is that?
And how can I get rid of this message?



Posted by Dave Hawley on April 04, 2001 4:24 AM

Hi Marcus

I'm guessing you still have the Modules in the Workbook, even though they are blank. Delete them as well.

OzGrid Business Applications

Posted by Marcus on April 05, 2001 7:28 AM


Funny how I never come to think of such obvious things by myself.