I'm trying to run macros that I did in Win Excel on the Mac, but fo
some reason I am getting errors. I am getting run-time errors o
simple things such as:

Private Sub CommandButton24_Click()

Sheets("Sheet 2").Select

End Sub


All of my command buttons have also become unclickable on the Mac. An
idea on how to solve this.

Thanks

Ca

--
Message posted from http://www.ExcelForum.com

Active X is a Windows-only technology, so Control Toolbox controls won't
work in MacXL.

Use controls from the Forms toolbar instead.

In article ,
wammer wrote:

I'm trying to run macros that I did in Win Excel on the Mac, but for
some reason I am getting errors. I am getting run-time errors on
simple things such as:

Private Sub CommandButton24_Click()

Sheets("Sheet 2").Select

End Sub


All of my command buttons have also become unclickable on the Mac. Any
idea on how to solve this.

Thanks

Cam
\

Thanks for the reply. I am now using forms and the buttons ar
definitely still clickable. I still, however get errors on the macro
themselves. I got a "Run-time Error 9: Subscript out of range on th
macro I was trying to run:

Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3", "Sheet 4", "Shee
5")).Select

Any idea why this might be?

Thanks again
Cam



JE McGimpsey wrote:
*Active X is a Windows-only technology, so Control Toolbox control
won't
work in MacXL.

Use controls from the Forms toolbar instead.

In article ,
wammer wrote:

I'm trying to run macros that I did in Win Excel on the Mac, bu
for
some reason I am getting errors. I am getting run-time errors on
simple things such as:

Private Sub CommandButton24_Click()

Sheets("Sheet 2").Select

End Sub


All of my command buttons have also become unclickable on the Mac.
Any
idea on how to solve this.

Thanks

Cam
\

--
Message posted from http://www.ExcelForum.com

One guess is that there's no space in the real sheet names??
Bob Umlas
Excel MVP

"wammer " wrote in message
...
Thanks for the reply. I am now using forms and the buttons are
definitely still clickable. I still, however get errors on the macros
themselves. I got a "Run-time Error 9: Subscript out of range on the
macro I was trying to run:

Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3", "Sheet 4", "Sheet
5")).Select

Any idea why this might be?

Thanks again
Cam



JE McGimpsey wrote:
*Active X is a Windows-only technology, so Control Toolbox controls
won't
work in MacXL.

Use controls from the Forms toolbar instead.

In article ,
wammer wrote:

I'm trying to run macros that I did in Win Excel on the Mac, but
for
some reason I am getting errors. I am getting run-time errors on
simple things such as:

Private Sub CommandButton24_Click()

Sheets("Sheet 2").Select

End Sub


All of my command buttons have also become unclickable on the Mac.
Any
idea on how to solve this.

Thanks

Cam
\ *


---
Message posted from http://www.ExcelForum.com/

Works fine for me in MacXL, if my sheet names have a space between
"Sheet" and the number.

In article ,
wammer wrote:

I got a "Run-time Error 9: Subscript out of range on the
macro I was trying to run:

Sheets(Array("Sheet 1", "Sheet 2", "Sheet 3", "Sheet 4", "Sheet
5")).Select

Any idea why this might be?