V
vivi
Hi there hope someone can shed some light for me...
I have written some codes for preparing data and it works fine for me when
running on my pc, however, when my colleagues run the macro, it gives error
message for debug. First i thought it was the add-in but it wasn't...Then I
thought it was the workbooks are not in separate windows, but i have chosen
that option for them already...
The code is running until it hits the code:
Windows("GSTT File Preparation").Activate
Can someone tell me how I can resolve this please?
Thanks a lot
I have written some codes for preparing data and it works fine for me when
running on my pc, however, when my colleagues run the macro, it gives error
message for debug. First i thought it was the add-in but it wasn't...Then I
thought it was the workbooks are not in separate windows, but i have chosen
that option for them already...
The code is running until it hits the code:
Windows("GSTT File Preparation").Activate
Can someone tell me how I can resolve this please?
Thanks a lot