Cancel Save As Feature

Morning,

I currently have the below code implemented to interrupt the save function in Excel. When someone tries to save it will give them the option to send an email to the owner of the file for a copy, or it will close the application. The issue comes when someone uses the SAVE AS function. When they cancel the userform when using SAVE AS it stops the code and opens the 'browse' window so the user can save before it then does the application.quit request.

is there a way to bypass this window? I've added the prompt for the useform below and the actual userform below that.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

frmSaveWarning.Show

End Sub

//this is the userform below//


Option Explicit
Private Sub cmdAbort_Click()

Unload Me
Application.EnableEvents = False
Application.Quit

End Sub

Private Sub cmdContinue_Click()

Dim OutApp As Outlook.Application
Dim OutMail As Outlook.MailItem
Dim StrSignature As String
Dim strUsername As String

strUsername = Application.UserName


Set OutApp = CreateObject("Outlook.application")
Set OutMail = OutApp.CreateItem(olMailItem)

With OutMail

.To = "sean.hickman@idealboilers.com"
.CC = ""
.BCC = ""
.Subject = strUsername & "MDS Copy Request"
.Body = strUsername & " has requested they have a copy of the Master Data Sheet, please contact them to discuss"

'walkout from the loading bar
.Display
Application.SendKeys "%s"
.Send

End With

End Sub