D
David Bartosik
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.
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.