Using PC worksheets with macros with Mac

[Leovigild]

Hello,

I've recently been unable to use worksheets made on a PC with the
Macintosh version of Excel (2001 at home, v.X at the office). Not only
don't the buttons work (which I believe is an Active-X problem from
searching here), but none of the macros work when I activate them
manually. I get error messages such as:

Run-time error '32809'

Application-defined or object-defined error.

Any ideas what might be wrong?

 

[JE McGimpsey]

Hello,

I've recently been unable to use worksheets made on a PC with the
Macintosh version of Excel (2001 at home, v.X at the office). Not only
don't the buttons work (which I believe is an Active-X problem from
searching here), but none of the macros work when I activate them
manually. I get error messages such as:

Run-time error '32809'

Application-defined or object-defined error.

Any ideas what might be wrong?

It's hard to tell without seeing what the code is. When you get the
error and click the "debug" button, what code is highlighted in the VBE?

Your button errors are likely exactly what you've described - ActiveX
currently works only on Windows machines.

If the macros are trying to access/manipulate the ActiveX controls'
properties, you'll get an app/object-defined error.

 

[Leovigild]

JE,

All of the buggy macros are of the form:

Sub ClearEvents()

' Application.Run "TurnAutoCalcOn"

ActiveSheet.Calculate
yada yada yada
ActiveSheet.Calculate

Application.Run "TurnAutoCalcOff"

End Sub

The debugger highlights the ActiveSheet.Calculate when the macro gives
the error message.

Scott