Hi Sandy,

To save the workbook without closing it, you can use the following code:

1. Formula:

   ActiveWorkbook.Save 


This will save the workbook without closing it. If you want to save changes made to the workbook, you can use:

1. Formula:

   ActiveWorkbook.SaveChanges 


This will save any changes made to the workbook without closing it.