Getting compile error in VBA

I have created an Excel dashboard for my users.  When I log into my client's server and run the Excel 2007 application, it runs without a problem.  

When one of the users open the Excel application he gets the error:

Compile Error:  Can't find project or library.

In the Debugger the following is highlighted:

ApplicationDisplayAlerts = False

The Option Button has the following VBA code attached to it:

If Range ("A1") = "Exit without Saving Changes" then
     ApplicationDisplayAlerts = False
     ActiveWorkbook.Close False
     Application.Quit
End If

How can I fix the problem when the users run this application from their desktops?

thanks

glen
GPSPOWAsked:
Who is Participating?
 
Martin LissOlder than dirtCommented:
It should be   Application.DisplayAlerts = False

Note the period.
0
 
GPSPOWAuthor Commented:
Thank you
0
 
Martin LissOlder than dirtCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2013
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.