R
Richard Smith
Greetings All.
I have a curious problem where some VBA code that I have crashes when
running a specific login of my Windows 2003 Server. I'm running Office XP.
The code chugs along fine and then all of a sudden it fails at a simple
font.bold command. If I break the code right before this command and then
step through it, it works fine. If I then continue the code, it fails again
at a later point on a simple rows.delete command.
Once it has failed I have the curious problem that I then am not able to
ever actually see the workbooks again. I am stuck in the VBA editor. If I
alt-tab back to one of the workbooks, the workbook appears to be activated
(e.g., when viewed in task manager) but I still only see the VBA editor.
If I run this very same code on the very same machine using any one of
several other logins, everything is hunky dory.
If anyone has any clues, I'd be much obliged.
Thanks in advance,
Richard.
I have a curious problem where some VBA code that I have crashes when
running a specific login of my Windows 2003 Server. I'm running Office XP.
The code chugs along fine and then all of a sudden it fails at a simple
font.bold command. If I break the code right before this command and then
step through it, it works fine. If I then continue the code, it fails again
at a later point on a simple rows.delete command.
Once it has failed I have the curious problem that I then am not able to
ever actually see the workbooks again. I am stuck in the VBA editor. If I
alt-tab back to one of the workbooks, the workbook appears to be activated
(e.g., when viewed in task manager) but I still only see the VBA editor.
If I run this very same code on the very same machine using any one of
several other logins, everything is hunky dory.
If anyone has any clues, I'd be much obliged.
Thanks in advance,
Richard.