I have this code in the area called "this workbook"
And this is macro 1
The issue I have now is that the macro keeps on repeating its self and saving all the time and the only way out is to push esc key. Is there anyway round this?
Thanks
VBA Code:
Private Sub Workbook_AfterSave(ByVal Success As Boolean)
Call Macro1
End Sub
And this is macro 1
VBA Code:
ActiveWorkbook.SaveAs Filename:= _
"https://xxrivagroup.sharepoint.com/teams/PASSACC/Shared%20Documents/General/shrek%20summary.xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWorkbook.Save
ActiveWorkbook.Close
The issue I have now is that the macro keeps on repeating its self and saving all the time and the only way out is to push esc key. Is there anyway round this?
Thanks