Posted to microsoft.public.excel.programming
|
|
Code not working on another comp
It says:
Runtime Error "9"
Subscript out of Range
We are both using XL 2002
-----Original Message-----
In article ,
says...
I have this code:
Private Sub CommandButton30_Click()
Windows("SWITCHBOARD").Activate
End Sub
It just switches you to a different open workbook. It
works just fine on my computer, but is doesn't work on
a
co-workers computer. He has Excel 2002, the security
is
set to Trust Access to Visual Basic Projects, but it
just
sends you the de-bug message.
Help?
G
*What* message?
What version of XL are you using?
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
.
|