ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Eliminate "Cancel" Button on Save/Close Event (https://www.excelbanter.com/excel-programming/427114-eliminate-cancel-button-save-close-event.html)

Excel Monkey[_2_]

Eliminate "Cancel" Button on Save/Close Event
 
Is it possible to create a to eliminate the Cancel Button when a user tries
to close or save a document. I am assuming that this would occur in the
BeforeClose event or the Before Save Event.

Thanks

EM

Patrick Molloy[_2_]

Eliminate "Cancel" Button on Save/Close Event
 
set the workbook's SAVED property to TRUE, and Excel won't propmpt h euser to
save the file

"Excel Monkey" wrote:

Is it possible to create a to eliminate the Cancel Button when a user tries
to close or save a document. I am assuming that this would occur in the
BeforeClose event or the Before Save Event.

Thanks

EM


Jacob Skaria

Eliminate "Cancel" Button on Save/Close Event
 
ActiveWindow.Close False


If this post helps click Yes
---------------
Jacob Skaria


"Excel Monkey" wrote:

Is it possible to create a to eliminate the Cancel Button when a user tries
to close or save a document. I am assuming that this would occur in the
BeforeClose event or the Before Save Event.

Thanks

EM



All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com