Need a save and close macro that does not care if the "edit workbook" button has be clcked

Hi,

You can try something like this
Add this to This Workbook section

Public SaveWtihoutMacro As Boolean

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

    If SaveWithoutMacro = True Then
        Cancel = True
    
    Else
    End If

End Sub

And this to your module section:

Sub Your_Button_Code()

SaveWithoutMacro = False

'Your code to saving goes here

SaveWithoutMacro = True

End Sub