Auto_open or On_open

  • Thread starter Thread starter Nathan Gutman
  • Start date Start date
N

Nathan Gutman

What is the difference between Auto_open and On_open?
Where can I find a written explanation?
Thanks,
Nathan
 
If you create the following in a standard module in a workbook:

Sub Auto_Open()
'do stuff
End Sub

it will be automatically executed when the workbook is opened.

On_open has no particular significance to Excel as far as I know.
 
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

Problem with workbook on_open event 1
Auto Open Macro 7
Dueling programs 1
Auto Refresh and Protecting a Sheet 3
Auto_Open Code on Worksheet 2
Macro to check for file update 1
Unexpected file change 4
Auto_Open and global variable 4

Back
Top