Vba Workbook Open Not Working. The code in question is contained inside an automatically-running subroutine, such as an Auto_Open or Auto_Close subroutine. Firstly it does not seem to run when I open up the workbook.
Re: Open and Hide a Workbook. Excel VBA Workbooks - Reference, Open, Add, Name, Save, Activate, Copy & Close Workbooks; SendMail Method. It will see that, then skip save, then close.
Firstly it does not seem to run when I open up the workbook.
With these, you can set off your code whenever the workbook is opened, or when someone clicks the "Print" or "Save" button, when you close.
Seems like a long time ago I figured out that there was a setting that needed to be checked. I am writing a vba macro to open and manipulate a Excel workbook from another Excel workbook. The code in question is contained inside an automatically-running subroutine, such as an Auto_Open or Auto_Close subroutine.