Read-Only alert when opening 2nd instance of Excel
Does anyone have any pointers to suppressing the message "Personal.xls
is locked for editing" when opening a 2nd instance of Excel? I usually
run some pretty big reports during the day, and while they're running,
I'll have a Windows scheduled task try to open an Excel workbook with
some VBA in the Open event. This opens a 2nd instance of Excel, but it
won't actually execute until I hit the 'Read Only' button. I'd like to
bypass this alert altogether if possible.
I thought setting Application.DisplayAlerts = False in the Open event
of the XLS file being opened by the 2nd instance would work, but it
doesn't. Perhaps the 1st instance controls the value of DisplayAlerts?
|