VBA- If user does not save then Exit sub

[Miya]

Hi, i want to add a control to the below code, if the user does not choose to save and cancels the save-as dialogue box, then Exit sub, do not continue to run the macro

Sub Test

'Call SaveAs dialog
     ChDrive [rngFileExport]
     ChDir [rngFileExport]
     CommandBars.FindControl(, 748).Execute



    Sheets(gstrGuide).Visible = xlSheetVeryHidden
    Sheets(gstrAssumptions).Visible = xlSheetVeryHidden
    Sheets(gstrRaw).Visible = xlSheetVeryHidden
    Sheets(gstrTasks).Visible = xlSheetVeryHidden
    Sheets(gstrAdmin).Visible = xlSheetVeryHidden

End Sub

 

[Miya]

Bump