Automatically run macros when file is opened

[rmwindham]

Hello, I have a macros that pulls rows from different sheets based on criteria and puts them on a summary sheet. My problem is I want the macros to run automatically when the file is opened. Any help will be appreciated.

 

[par60056]

What you are talking about is an event procedure. If you are in the VBA editor dbl click the ThisWorkbook object under the Microsoft Excel Objects. It will open a code module with a title "workbookname - ThisWorkbook (Code)" Change the left dropdown to Workbook and it should create a "Private Sub Workbook_open()" Insert code.

 

[rmwindham]

Beautiful, worked great, thanks

 

[par60056]

Thanks for the feedback. glad it helped.