PC Review

Thread Tools Rate Thread

Re: Enabling Macros message when NO macros in workbook

Stan Brown
Posts: n/a
      5th Aug 2012
On Sat, 04 Aug 2012 14:20:59 -0500, Jack Deuce wrote:
> In order to fix a problem in 117 worksheets I created a macro to
> basically FORMAT, PROTECTION, check Locked, and check Hidden, then
> CTL-PGEDOWN to advance to the next worksheet. After formatting all
> the sheets, I deleted the macro, TOOLS, MACRO, MACROS and delete.

You deleted the macro, but you didn't delete the module that contains
it. Excel apparently is not smart enough to distinguish the empty

Open your workbook and press Alt-F11 to bring up the Visual Basic
editor. In the explorer-style list at the top left, find your
workbook name. Double-click to expand it, if necessary. Double-
click on the module to see the code and make sure you haven't
forgotten about any other macro. The right-click the module and
delete it. Close VB Editor and then in Excel save the workbook.

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
Shikata ga nai...
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Enabling Macros message when NO macros in workbook James Ravenswood Microsoft Excel Worksheet Functions 0 4th Aug 2012 09:08 PM
Enabling macros for my workbook Maddoktor Microsoft Excel Programming 1 25th Feb 2006 03:42 PM
Macros, not enabling them or disabling them but stopping the warning message. Derrick Fawsitt Windows XP General 8 19th Feb 2004 11:41 AM
enabling macros message - make it stop! amanda Windows XP General 5 4th Jan 2004 10:26 PM
Enabling Automatic Update tab in the system properties and enabling the service. Ikram Windows XP Setup 2 25th Aug 2003 12:23 AM




All times are GMT +1. The time now is 01:18 PM.