VBA/Excel – auto run a macro

I’m new to VBA and I want to have a macro auto-run when ever a certain Excel workbook is opened. The macro I created works but I don’t know how to automate it. I would also need to run a similar marco when that workbook is closed. Can anyone helpme?

Please respond to CBDepadua@laneconstruct.com