tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,212
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
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
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
Code:
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