<<Convert Excel Spreadsheets to Web Pages \| Trading Software That Operates Within Excel \| Convert Excel, Access & Other Databases \| Merge Excel Files>>

Stop UserForm From Closing via X

| | Information Helpful? Why Not Donate.

TRY OUT: Smart-VBA | Code-VBA | Analyzer-XL | Downloader-XL | Trader-XL| More Free Downloads.. Best Value: Finance Templates Bundle

Prevent Closing of UserForm via Top Right X

Got any Excel Questions? Excel Help

Stop Top Right X Click

The code below can be placed in the Private Module of any UserForm Object to prevent any users closing the Excel UserForm via the top right X. It makes use of UserForm_QueryClose Event to capture the click on the top right X. The Cancel being set to True prevents the UserForm from closing when the top right X is clicked.

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)        If CloseMode = 0 Then Cancel = TrueEnd Sub

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALLpurchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software

Try out:Analyzer XL |Downloader XL |Smart VBA |Trader XL Pro (best value) |ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader PackageTechnical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft