| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking a workbook when it is opened
I want Excel to check the data on every workbook that gets opened. If
certain criteria are met, then some processing will be carried out. I have set up the event Workbook_Open to run, and this gets triggered ok. I have a problem with this though. When I open an existing workbook with Excel not previously running, the open routine gets triggered twice. I guess that this is once for the PERSONAL.XLS workbook and then again for the actual workbook. This is a problem, as when it gets triggered the first time, the PERSONAL.XLS sheet is hidden so if I try to look at anything on the sheet, the code falls over. Any assistance would be appreciate... Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checking whether .xls file was just opened from a template | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
| Checking for who opened Excel | Excel Programming | |||
Threaded Mode
