This VBA code will save an Excel workbook file and close it when it runs. You could put a button or some other trigger on your worksheets to initiate the macro so that it’s easier for your users to access the macro.
Instructions to Install VBA to Save Workbook with No Prompt
Step 1: Copy paste this Save and Close VBA macro in to a new module
Sub SaveAndClose() ActiveWorkbook.Close SaveChanges:=True End Sub
Step 2: Make whatever changes you want to the worksheets / workbook.
Step 3: Run the macro and it will save the changes that you made and close the work book.