I have a workbook that has several things that monitor movement on sheets.
Before I close and before I save (in the appropriate functions) I issue On
Error Goto 0 but when I type data on a new workbook the sub for workbook_Open
runs and the previously closed file reopens and I get an error message as
some of the tabs on the current sheet are not the same name that the one that
was closed refer to. Why can't I get this previous workbook's functions to
quit "holding on" and running?