error in our macro oder form....only some computers

[Guest]

we have an office with about thirty computers running xp pro w sp2.
Originally there was 10 individuals that were working with a macro oder form
in excel. We are now adding another 10 people that will be using this order
form, but have found that the excel macro oder form will only work on some of
the machines. We run a mix of office 2000 & 2003. The error I get does not
seem to be related to the version of excel we are using. I get an error
opening the excel sheet in office 2003 while our secratary opens the same
sheet in excel 2003 with no erorrs. Vice Versa with office 2000. The
message I get when trying to open the file is "compile error in hidden
module: this workbook". I have looked at other posts that seem to mention
adobe PDF as the culprit, but it does not seem to be the same issue as mine.
Any idea's where to start?

 

[Nick Hodge]

Bob

Try unchecking the add-ins under Tools>Add-ins... and close Excel...add each
one back, one at a time and close and re-open Excel in between... when the
issue goes away that's the problem add-in, once you have isolated this post
back if you still have problem with the original macro

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)