-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
closemode
-
P
How to call Workbook_BeforeClose Event when commandbutton is pressed
Option Explicit Private Sub CommandButton1_Click() Workbook_BeforeClose End Sub Private Sub UserForm_Initialize() Me.Caption = "Print, Save and Close" With Me.Label1 .Caption = "Do you want to print, save and close the workbook named: " & """" & ActiveWorkbook.Name & """"...- Pookiemeister
- Thread
- closemode end integer private workbook_beforeclose
- Replies: 1
- Forum: Excel Questions
-
S
How to use the 'X' button to cancel
Hello Everyone, I am having trouble when using my forms. Whenever I used this code, the form will not allow me to close the form using the 'X' button and instead having to click cancel to close. I have been tasked to takeover a marco from a previous designer and I am wondering if there is a way...- SamsonL
- Thread
- cancel closemode end form
- Replies: 3
- Forum: Excel Questions
-
R
UserForm X disabling
Hi all, I am trying to disable the X on some userforms and have the following code: Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) If CloseMode = 0 Then Cancel = True End Sub But when I run the code, it tells me "user-defined type no defined" Am I placing...- renderman7
- Thread
- closemode code integer run user-defined
- Replies: 6
- Forum: Excel Questions
