ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disabling 'Cancel' option when saving work (Yes/No/Cancel) (https://www.excelbanter.com/excel-programming/366902-disabling-cancel-option-when-saving-work-yes-no-cancel.html)

[email protected]

Disabling 'Cancel' option when saving work (Yes/No/Cancel)
 
Hi Everyone,

I was wondering if there was a way to only allow the Yes/No options to
save a workbook after a user closes a form. I have minimized all
worksheets and set them behind my forms where they are out of view. I
found that selecting 'cancel' would allow users to maximize my
worksheets. I have some hidden worksheets already, but I have to keep
at least one of them unhidden.

Thank you!
Jorge



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

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