So in what workbook or add-in is the module modCustomFunctions? If it's not
in your client xls then it is presumably in an add-in. What add-ins are
being loaded under Excel Options, Add-ins?

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