How do I stop this macro wanting to ask me for extra permissions everytime I run this macro on a mac excel

[tonywatsonhelp]

Hi Everyone,
I have this macro that works great even on a Mac with latest Excel.

however annoyingly it asks for extra permitions when I try running it every time.

Can I stop it from asking me for permion by adding something to the code?

thanks

Tony

Sub Finished()
Application.DisplayAlerts = False
    Dim thisWb As Workbook
    Dim newFile As String, fName As String
    Set thisWb = ActiveWorkbook
 
   fName = Sheets("Staff Pay Report").Range("L3").Value
    newFile = Format(fName, "dd-mmmm-yyyy")
 
    ActiveWorkbook.SaveAs Filename:="Week Ending " & newFile & ".xlsm"

Application.DisplayAlerts = True

 
End Sub

 

[RoryA]

Welcome to the wonderful world of sandboxing. Have a read of this: Problems with Apple’s sandbox requirements and Mac Office 2016 with VBA code