workbook open event

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

I have a public sub call "Test1". I want to make this
macro run when the workbook is open but I'm not sure how
to use the workbook open event. Any help would be greatly
appreciated. Thanks...
 
Private Sub Workbook_Open()
'YOUR CODE
End Sub

put this in the "ThisWorkbook" module
 
Put this in the ThisWorkbook code module (with Test1 in a regular code
module):

Private Sub Workbook_Open()
Test1
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COM addin won't connect when workbook opened via another workbookfrom another instance 3
Calling subroutine defined in another workbook (autostart workbook) 5
Excel is removing Macros from workbook 3
Opening a list of Excel files and run a macro in each 17
Which Excel event to call when opening a .txt file 1
Unwanted workbooks on startup 2
How to Unlock Excel Workbook protected by MACRO Password 6
Problem with workbook on_open event 1

Back
Top