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.

[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

[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 Auto_Open 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

"PeteM" <PeteM.1pm49s_1117066314.9241@excelforum-nospam.com> wrote in
message news:PeteM.1pm49s_1117066314.9241@excelforum-nospam.com...
>
> 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.
>
>
> --
> PeteM
> ------------------------------------------------------------------------
> PeteM's Profile:
> http://www.excelforum.com/member.php...o&userid=23736
> View this thread: http://www.excelforum.com/showthread...hreadid=374104
>

[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...%40cppssbbsa04

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

Jerry

PeteM wrote:

> 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.