View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Hawk The Hawk is offline
external usenet poster
 
Posts: 23
Default Closing Excel w/o Error message

I have an Excel workbook that uses forms for data entry. An EXIT command is
built into the entry forms which closes the workbook fine. My problem is
that the entry forms can be closed (hidden) to allow te users to navigate
through the different sheets to review data and/or print. If a user clicks
on the Window actions in the Upper Right (X) or through File / Exit and not
through the entry form the application returns the "Micsoft Excel has
encountered a problem" error message.

What is the best way to eliminate this error in Code and where in the code?
In the Entry Form code or This Workbook?

Thanks...