MACROS IN MULTIPLE SHEETS
 

WHEN YOU HAVE TWO SEPARATE APPLICATIONS RUNNING WITH MACROS AND YOU SWITCH
BETWEEN THE TWO THEY WILL ERROR OUT UNTIL YOU RE-ENTER A VALUE MAKING THE
SHEET REGENERATE. IS THERE A WAY TO AVOID THIS ERROR AND HAVE IT REGEN
AUTOMATICALLY. OBVIOUSLY I COULD JUST OPEN UP A NEW EXCELL DOC AND RUN TWO
EXCELLS BUT THIS IS PAINFUL WHEN THE FILE YOU NEED TO OPEN IS 20 STEPS IN OUT
ON A SERVER. ANY HELP?