Disable Macro Message - No Macros

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

When opening a workbook I get the enable/disable macro
dialog box. There is no macro in the workbook and I'd
like to stop the message occurring - it's confusing the
users. The workbook did, at one time, contain some macros
but does no longer - the list under Alt-F8 is empty. How
do I stop the message being displayed when the workbook
opens?
 
The Alt F8 list does not necessarily show all macro code.

Open the VB editor (Alt F11). In the project explorer up left, remove all modules
(rightclick > remove). Then doubleclick every other object (Sheet1, Sheet2, ThisWorkbook,
....) in the same explorer and remove absolutely all text that may be there. Save.
 
Try checking each sheet for code while in the Visual Basic
Editor, sometimes there are event macros in there. A good
bet might be code on 'ThisWorkbook'.
 
Wayne,

Usually, this is due to the fact that even though the macros,
themselves, have been deleted, the module(s) that held them still
exist.

1.) Go into the Visual Basic Editor (Alt+F11 is a shortcut).
2.) Find the file in question in the Project pane (usually the left
pane on the screen).
3.) If you find a folder called "Modules" under that file, click the
"+" sign next to it, and a list of modules will appear. (More than
likely, you'll only find Module1.)
4.) Double-click on it to view its contents in the right pane. If
there's nothing there, them that's the culprit.
5.) Right-Click on the module in the left pane (again, it's probably
Module1), choose Remove Module1 on the pop-up menu and answer No to
export before deleting.
6.) Save the file and close it.

The next time you open the file, you shouldn't get the Enable/Disable
Macro Dialog box.

I hope this solved your problem.
Paul
 
Back
Top