I've determined the source of the problem is the existence of the new iferror
function in excel 2007.
these are client excel files that contain 3rd party custom code which is
protected and hence inaccessible. the custom code has a custom iferror
function.
so excel 2007 basically blows up.
the only option I can think of to get around this is if the excel 2007
iferror function can be disabled, that is globally on the program side, not
file specific.
can a built in function be turned off?


"Jon Peltier" wrote:

The #NAME probably comes up when the workbook is opened without enabling
macros, so the UDFs are not recognized. When macros are enabled, it would
make the #NAME error go away, but any procedures that alter the commandbars
may give you the compile error, since 2007 only marginally supports
commandbars. Sure, some custom buttons will be added to the add-ins tab. But
if the code inserts a button in a particular place on a particular menu or
command bar, say, before the "Print" control, it can't find the Print
control, and you get the error. I had to completely redo my personal macros
workbook because of this incompatibility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"David" wrote in message
...
running excel 2007 on windows vista.

have a client xls file that I know has macros and that is a protected
workbook.

I have zero issues with the file in excel 2003 when I open the file. all
data is there and intact and valid.

in excel 2007 however several sheets in the workbook have all the cells go
to #NAME

I went into excel 2007 options and trust center options and turned on the
enable all macros option to resolve that.

however with that option on I get the VB error dialog - compile error in
hidden module modCustomFunctions

and the ok button and close is useless. excel has to be end tasked.

excel 2007 becomes unuseable, the xls file unopenable.

I have found zero documentation on the modcustomfunctions

I have found documentation on compile error in hidden module, but nothing
that is applicable here. I have zero files in both xlstart folders and
have
Adobe reader 8.

so I need help with resolving the issue of the vb error when macros option
is turned on or being able to get the data values when macros is off.