ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatic Macro Start (https://www.excelbanter.com/excel-programming/282033-automatic-macro-start.html)

Edgar[_3_]

Automatic Macro Start
 
Hi

I was wondering how automatically run a macro everytime i
open a workbook.

Thanks

Ture Magnusson

Automatic Macro Start
 
Edgar,

1. In the Project Explorer window, double-click "ThisWorkbook"
2. Create a Workbook_Open procedure, something similar to this:

Private Sub Workbook_Open()
MsgBox "Hello there!"
End Sub

3. Save the workbook.

Ture Magnusson
Karlstad, Sweden

"Edgar" wrote in message
...
Hi

I was wondering how automatically run a macro everytime i
open a workbook.

Thanks





All times are GMT +1. The time now is 01:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com