![save as with excel vba on open event save as with excel vba on open event](https://www.lesgourmetsrestaurants.com/wp-content/uploads/2020/05/excel-vba-workbook-open-worksheet.jpg)
SAVE AS WITH EXCEL VBA ON OPEN EVENT HOW TO
In this article, I will tell you how to run the VBA code while opening or closing the workbook every time.ġ.
![save as with excel vba on open event save as with excel vba on open event](https://www.al-mscoastallaw.com/wp-content/uploads/2021/07/excel-vba-open-workbook-save-as.jpg)
But have you ever tried to run the VBA macro in each time of opening or closing the workbook.
![save as with excel vba on open event save as with excel vba on open event](https://slidetodoc.com/presentation_image/340a3ec0883f9c7111bc0d75ebd440d0/image-28.jpg)
In many cases we may use the VBA code to achieve the operations which Excel built-in functions not support. How to run VBA macro when open or close workbook?