Hazel, try Rob Bovey's code cleaner at
http://www.appspro.com/Utilities/CodeCleaner.htm. It sounds like you have
old userforms and modules and perhaps replacing with new ones will solve.
I'm suspecting that very old ones do not get along well with Excel 2007.
Let us know.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Hazel" wrote in message
...
We recently changed to Office 2007 all our previous work done in Excel
2003.
Almost immeadiately our 2003 programs using in house designed UserForms
began
giving us problems -- we have tried all the new file extensions etc all
to
no avail -- the only way we seem to be able to resolve the problem is that
on
opening Excel we have to compile and save in VBA then everything runs ok
in
that program, if we have to close down Excel and then reopen again its
compile and save before use. We have tried compile and save before closing
again it will not run without compile and save on re-opening. Any
suggestions
out there??? re-writing in 2007 is not really an option some of the stuff
is
to big.
--
Many thanks

hazel