Totte Wrote:
Hello all,

We have developed a VBA-program in Excel 97 which works fine in Excel
2000
and Excel XP but when we test it with Excel 2003 we recieve the error
message
"Compile error in hidden module: Module 1".
Does anyone know the reason to this error message?

Totte

The references are most likely missing however because it says Hidden
module more than likely the project is protected. does this workbook
email itself or anything. as a lot of time it has a reference to
outlook say 2000 or xp then you try 97 it does not recognise it. you
will find if you have the complete package of office 2000 and xp. if
you run the workbook on 2000 save the file open it on xp it save it
then try open the file again in 2000 you should get the same message
this is because it can upgrade the references but not the downgrade
them.

hope this helps as i have had similar problems with a workbook which
emails data off.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=516859