Compile error: Automation error

[Debbie]

Greetings, I have a very small excel spreadsheet that was created on a
PC but many users run on a mac. The error occurs on the following:

Sub Show()
emails.show
end sub

That's it. These users get a "Compile Error: Automation error"
error. The spreadsheet opens to a button control. They click the
button to open the form and that's what happens. I'm not a mac user
so any thoughts would be appreciated. Thank you.

 

[Bob Greenblatt]

Greetings, I have a very small excel spreadsheet that was created on a
PC but many users run on a mac. The error occurs on the following:

Sub Show()
emails.show
end sub

That's it. These users get a "Compile Error: Automation error"
error. The spreadsheet opens to a button control. They click the
button to open the form and that's what happens. I'm not a mac user
so any thoughts would be appreciated. Thank you.

It's a little hard to say for sure. Is emails the name of a user form in the
workbook? The most likely cause for the problem is that the creator of the
workbook on the PC has used Active X controls. These are not supported on
the Macintosh. Rebuild the application using controls from the forms
toolbox.

 

[Debbie]

It's a little hard to say for sure. Is emails the name of a user form in the
workbook? The most likely cause for the problem is that the creator of the
workbook on the PC has used Active X controls. These are not supported on
the Macintosh. Rebuild the application using controls from the forms
toolbox.

Thanks, Bob. I wish I knew how to do that. I'll have to find some
user form tutorial. It's so not like what I'm used to on a PC.
Thanks again.

 

[Bob Greenblatt]

Thanks, Bob. I wish I knew how to do that. I'll have to find some
user form tutorial. It's so not like what I'm used to on a PC.
Thanks again.

Did you create the form on the PC? Who wrote the macros supporting the form?
We can help here with any problems you may have. If active X controls are
indeed the cause of the problem, the application will have to be redesigned
to be able to work properly on both platforms.