Hi,
I have setup a macro that will run every 1 minutes but when I am in another workbook the macro stop and there is an issue because the macro cannot find the sheet defined in the macro.
Is there a way to specify that the macro run only in its workbook ?
Thanks,
Here is my macro :
I have setup a macro that will run every 1 minutes but when I am in another workbook the macro stop and there is an issue because the macro cannot find the sheet defined in the macro.
Is there a way to specify that the macro run only in its workbook ?
Thanks,
Here is my macro :
Code:
Sub MAJ()
' MAJ Macro
Sheets("Spread").Select
Application.Run "BLPLinkReset"
ActiveSheet.ListObjects("Tableau2").Range.AutoFilter Field:=1, Criteria1:= _
"Alerte"
Application.OnTime Now + TimeValue("00:01:00"), "MAJ"
End Sub