G'day,
My question is similar to LeoExcel's unanswered question Here, where the workbook is NOT to be saved when the UserForm is closed/hidden.
Here is my code:
Now, the MsgBoxes are there only for me to see when the workbook is saving - which is after the "After Hide" MsgBox is closed. You see, my problem is exactly like LeoExcel, where I do NOT want the workbook to close (i.e. the UserForm is to get info from the user for the location to save the workbook. The user may want to make other changes before saving the workbook to the server).
(I'm using vba in Excel 2002)
Thank you,
Mitch
My question is similar to LeoExcel's unanswered question Here, where the workbook is NOT to be saved when the UserForm is closed/hidden.
Here is my code:
Code:
Private Sub ReturnToSheet_Click()
MsgBox "Before Hide"
SaveForm.Hide
MsgBox "After Hide"
End Sub
(I'm using vba in Excel 2002)
Thank you,
Mitch