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