Using Macros is PC developed worksheet in Max Excel (v.X)

[Anthony]

I'm relatively new to mac having just converted last Dec.

I have a spreadsheet I developed in Excel for PC, that has a Macro
built and a button assigned to it. Using Excel for Mac (v.X) the
button won't work and the macro won't run. I read that the ActiveX
controls don't work in MacXL so I used the forms toolbar, created a
new button and assigned the macro to it. Now when I push the button,
I get the following errror message: "Can't exit design mode because
Control 'CommandButton1' can not be created."

When I attempt to enter the macro and run it directly from there, I
get this message: "Application-defined or object-defined error."

Following is the Macro. Any thoughts? It is designed to help sales
people track sales prospects and closings.

Sub Complete_Macro()
'
' Complete_Macro Macro
' Macro recorded 2/15/2002 by bradc
'

'
ActiveSheet.Unprotect Password:="ab"
Range(ActiveCell, ActiveCell.Offset(0, 2)).Select
Selection.EntireColumn.Hidden = False
ActiveCell(0, 1).Select
ActiveCell.Offset(1, 1).FormulaR1C1 = "-1"
ActiveCell.Offset(0, 1).Select
Selection.EntireColumn.Hidden = True
ActiveCell.Offset(1, -1).Select
ActiveSheet.Protect Password:="ab", DrawingObjects:=True,
Contents:=True, Scenarios:=True
End Sub


Thanks in advance for any help.

 

[JE McGimpsey]

I have a spreadsheet I developed in Excel for PC, that has a Macro
built and a button assigned to it. Using Excel for Mac (v.X) the
button won't work and the macro won't run. I read that the ActiveX
controls don't work in MacXL so I used the forms toolbar, created a
new button and assigned the macro to it. Now when I push the button,
I get the following errror message: "Can't exit design mode because
Control 'CommandButton1' can not be created."

Buttons from the Controls toolbar are ActiveX controls, which aren't
supported on Macs. Use a Forms toolbar button instead.