View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
G[_5_] G[_5_] is offline
external usenet poster
 
Posts: 8
Default 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
.