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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks