There are 3 break on error options in Excel and the options is part of
the installed software on the PC and is not part of the workbook.

The optionis in the VBA menu tools - OPtions General - Error Trapping.

Try changing the option. Most likely the mode got changed to "Break on
All Errors". the macro probably alway had the error and would of
occured i 2003 as well as 2007. But there also were lots of new error
created in 2007.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=177576

Microsoft Office Help