How to run a macro as soon a a workbook (.xls) is opened?
How to run a macro as soon a a workbook (.xls) is opened?
|
How to run a macro as soon a a workbook (.xls) is opened?
Use the Workbook_Open event. In Excel right click the Excel Icon just
left of the File Menu. Select View Code. Paste the following and change as required: Private Sub Workbook_Open() MsgBox "Hello World!" End Sub Hope this helps Rowan Sangamesh Acharya wrote: How to run a macro as soon a a workbook (.xls) is opened? |
All times are GMT +1. The time now is 08:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com