F Frank Kabel Mar 23, 2004 #2 Hi Ian two ways: 1. In your workbook module (not in a standard module) use the Workbook_Open() event procedure 2. Rename your macro to Auto_Open()
Hi Ian two ways: 1. In your workbook module (not in a standard module) use the Workbook_Open() event procedure 2. Rename your macro to Auto_Open()
J JOhn Mar 23, 2004 #3 -----Original Message----- HI, How do I get a macro to run as soon as the workbook opens? Thanks Ian . Click to expand... Hi Ian, The function I use is: Private Sub Workbook_Open() 'main body of your macro End Sub I wouldnt be the worlds biggest VBA expert but as far as I know this has to be contained inside the ThisWorkbook part of the VBAProject Hope that help, John
-----Original Message----- HI, How do I get a macro to run as soon as the workbook opens? Thanks Ian . Click to expand... Hi Ian, The function I use is: Private Sub Workbook_Open() 'main body of your macro End Sub I wouldnt be the worlds biggest VBA expert but as far as I know this has to be contained inside the ThisWorkbook part of the VBAProject Hope that help, John
G Guest Mar 24, 2004 #4 big thanks to both of you ! Sorted! -----Original Message----- Hi Ian, The function I use is: Private Sub Workbook_Open() 'main body of your macro End Sub I wouldnt be the worlds biggest VBA expert but as far as I know this has to be contained inside the ThisWorkbook part of the VBAProject Hope that help, John . Click to expand...
big thanks to both of you ! Sorted! -----Original Message----- Hi Ian, The function I use is: Private Sub Workbook_Open() 'main body of your macro End Sub I wouldnt be the worlds biggest VBA expert but as far as I know this has to be contained inside the ThisWorkbook part of the VBAProject Hope that help, John . Click to expand...
