Macro cannot be disabled nor signed.

[PeteM]

Following Error message.

"This workbook contains a type of macro (Microsoft Excel version 4.0
macro) that cannot be disabled nor signed. Therefore, this workbook
cannot be opened under High Security Level."

Why is this happening....and what is the solution.

 

[Robin Hammond]

Pete,

You have an Excel 4 macro in the workbook. It's a completely different
language to VBA.
The Excel help system has this to say: "You may be trying to open a workbook
that contains a type of macro that cannot be disabled. Excel has two types
of macros: those written in Visual Basic for Applications (VBA) and those
written in Excel version 4.0 macro language (XLM macros). Only macros
written in VBA can be disabled. When you open a workbook that contains XLM
macros, the Autpen macro can be disabled, but other XLM macros still run.
It is recommended that you make sure that the source of the workbook is
reliable before you open the workbook."

Set security to medium (Tools, Options, Security, Macro Security), if you
trust the originator of the file. Try opening it. Unhide any sheets that are
not visible, and look for the offending macro in the sheets.

Robin Hammond
www.enhanceddatasystems.com

 

[dominicb]

Good morning PeteM

Fom Excel 97 onwards, the macro language of choice within XL is VBA,
however before XL97 you had to use XML (eXcel Macro Language). XML is
nowhere near as powerful as VBA but it did the trick. The workbook you
are trying to open has an XML macro that has probably been written using
Excel 95 or below. Your version of XL will still run this macro - if
you trust it - but it cannot be disabled. At present you have high
security invoked on your machine and must lower it to open the
workbook. Use Tools > Macro > Security and set it to medium. This
always gives you the option whether to run the VBA macros but you must
allow XML macros to run.

HTH

Dominic

 

[Jerry W. Lewis]

Aside from the obvious explanation that there may be Excel 4 macros in
the workbook, Solver can add hidden names to workbooks that may be
mistaken for Excel 4 macros in some versions of Excel. Jim Rech's code

http://groups.google.com/groups?selm=etcItvDs$GA.194@cppssbbsa04

can be used to delete all names in a workbook, including the Solver
residues.

Jerry