Closing Excel
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 |
All times are GMT +1. The time now is 09:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com