Is there a way to disable pressing the "x" at the top right corner of the
screen from closing an Excel document. Here's my dilema: I have created
workbooks that I allow beginner-level users to use to access data. In these
books, there are buttons that perform all of the actions, including saving
and closing the documents. However, I have trouble making the users press
the buttons instead of pressing close or"x" in Excel, closing the document
wherever they want and not leaving it appropriately for the next user. Is
there a way to temporarily disable them from closing Excel this way? Thanks
in advance.
-Chad

Sounds like you could run your code on the Workbook_BeforeClose event in
addition to your button...
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


"Chad" wrote in message
...
Is there a way to disable pressing the "x" at the top right corner of the
screen from closing an Excel document. Here's my dilema: I have created
workbooks that I allow beginner-level users to use to access data. In
these
books, there are buttons that perform all of the actions, including saving
and closing the documents. However, I have trouble making the users press
the buttons instead of pressing close or"x" in Excel, closing the document
wherever they want and not leaving it appropriately for the next user. Is
there a way to temporarily disable them from closing Excel this way?
Thanks
in advance.
-Chad

I would prefer just to "disable the close" without using the button because
there could be one of many different sheets they close on when the user is
finished with the book. Thanks for the insight. Any other thoughts?

"Anne Troy" wrote:

Sounds like you could run your code on the Workbook_BeforeClose event in
addition to your button...
*******************
~Anne Troy

www.piersontech.com
www.mrexcel.com


"Chad" wrote in message
...
Is there a way to disable pressing the "x" at the top right corner of the
screen from closing an Excel document. Here's my dilema: I have created
workbooks that I allow beginner-level users to use to access data. In
these
books, there are buttons that perform all of the actions, including saving
and closing the documents. However, I have trouble making the users press
the buttons instead of pressing close or"x" in Excel, closing the document
wherever they want and not leaving it appropriately for the next user. Is
there a way to temporarily disable them from closing Excel this way?
Thanks
in advance.
-Chad