| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
| macros over different sheets | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Macros - get information from Multiple sheets in a work book? | Excel Programming | |||
| Changing the value in multiple sheets without selecting those sheets | Excel Programming | |||
Threaded Mode
