Скачать или смотреть Excel Macro which will Save your workbook

In this video we outline the code that is needed to Save the workbook. This can be useful at the start of a macro, before the rest of the code runs, or right at then end after the code has been executed, depending on your desired application.

The code we used in this example is as follows.

Private Sub CommandButton1_Click()

Sheets("Sheet1").Range("A4").Select
ActiveCell.EntireRow.Insert shift:=xlDown

Sheets("Sheet1").Range("A4:E4").Select
Selection.Borders.Weight = xlThin

ActiveWorkbook.Save

End Sub

The code we are interested in to save the workbook is:

ActiveWorkbook.Save

Paste this into your own code at the location you wish the macro to save your workbook.

To download a copy of this workbook please visit the website at the hyperlink below.

http://twoperscent.com/index.php/2017...

If you have any questions then please put these in the comments.