Running Win Macros on Mac

[wammer]

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

 

[JE McGimpsey]

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

Use controls from the Forms toolbar instead.

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

\

 

[wammer]

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

 

[Bob Umlas]

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

 

[JE McGimpsey]

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