ExcelBanter - Protect Forms

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Protect Forms (https://www.excelbanter.com/excel-programming/283038-protect-forms.html)

Matt[_20_]

Protect Forms

Is there any way to make it so that a form cannot be
closed or minimized while keeping the controls on the form
useable?

Harald Staff

Protect Forms

If it's a VBA userform, you can trap and Cancel this in the UserForm_QueryClose event.
--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Matt" wrote in message
...
Is there any way to make it so that a form cannot be
closed or minimized while keeping the controls on the form
useable?

All times are GMT +1. The time now is 01:44 AM.