close

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 quot;Hello World!quot;
End Sub

Hope this helps
Rowan

Sangamesh Acharya wrote:
gt; How to run a macro as soon a a workbook (.xls) is opened?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()