ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro upon opening (https://www.excelbanter.com/excel-worksheet-functions/112537-macro-upon-opening.html)

Peanut

Macro upon opening
 
Is there a way to create a macro that runs immediately upon opening of a
worksheet?

Dave Peterson

Macro upon opening
 
You can use a macro named Auto_Open() in a General module:

Option Explicit
Sub Auto_Open()
msgbox "hi"
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Peanut wrote:

Is there a way to create a macro that runs immediately upon opening of a
worksheet?


--

Dave Peterson


All times are GMT +1. The time now is 10:12 PM.

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