Hi all.

So I am very new to VBA/Macros most of my programming experience is in scripting languages like python. I have looked at previous post but nothings seems to solve my problem.

I am currently setting up an excel sheet that contains a fair amount of macros as to guide end-users when the sheet is filled in. Finally I want the sheet to be saved as a normal xlsx by the click of a bottom on the sheet.

I have a macros button that points to this :

Sub SaveAS()
ActiveWorkbook.Application.EnableEvents = False
ActiveWorkbook.Application.DisplayAlerts = False
ActiveWorkbook.SaveAS Filename:="New_Sheet.xlsx", FileFormat:=52, ConflictResolution:=xlLocalSessionChanges
MsgBox "Your Sample Sheet has been saved"
ActiveWorkbook.Application.DisplayAlerts = True
ActiveWorkbook.Application.EnableEvents = True
End Sub
This works but it still results in an alert that when saving as xlsx that macros will be removed. I was under the impression that Application.DisplayAlerts = False would disable the alerts and the SaveAs would just "happen"

Help would be appreciated