Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: June Carroll on Jan 12 In MS Office Category.

Stopping users from "x-ing" out of a workbook

Question Answered By: Barabas Cohen on Jan 12

You are close, try this below

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As
Integer)
If CloseMode = VbQueryClose.vbFormControlMenu Then
Cancel = True
End If
End Sub

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Stopping users from "x-ing" out of a workbook Or get search suggestion and latest updates.

Related Topics:

Stopping users from "x-ing" out of a workbook
Change Workbook's Name
Making a Workbook as an Active Workbook without opening it
Next Workbook or Previous Workbook
Prob running workbook activate code when workbook is opened by anot
Run Macor in a closed workbook and refer to the closed workbook
User input in creating a Excel Workbook
More on grey-outs
No grey-outs in other DEs or WMs
Simplest way to check for a blank worksheet in an excel workbook
how upate daily datewise data form one workbook to another
referencing another worksheet in different workbook?
Find a match in a range and copy contents to templates workbook
Workbook and Worksheet manipulation
setting the name in a workbook
My Personal Macro Workbook Won't Show
GETTING CUSTOMER NAME FROM ANOTHER WORKBOOK THRU PUBLIC FUNCTION
How To Edit Workbook in XML Level
Removing the VBA SourceCode from the Workbook
Workbook update issue

Tagged:stopping users from x ing out of workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us