Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

compile error: automation error

Status
Not open for further replies.

benniesanders

Programmer
Jan 20, 2002
199
US
Greetings, I'm not sure I'm even posting in the right place, but I couldn't find a better place, so here goes...

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

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top