Inside Microsoft Excel

Disable the Close button to ensure your dialog box gets the attention it needs

Inside Microsoft Excel

by Kara Hiltz

When you create a dialog box with VBA, it’s frustrating to think that anyone can dismiss it in one click. This means that the hard work you spent on creating a dialog box that serves an important purpose (often to the user’s advantage!) goes to waste. For instance, in the accompanying article “Tailor your workbook’s data while ensuring a clean slate for coworkers,” a colleague can sidestep the dialog box we create[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)