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

Hi,

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?

Regards

Marcus


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.

Dave
OzGrid Business Applications

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

Thanks,

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

/Marcus