ExcelBanter - Auto_open or On

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Auto_open or On_open (https://www.excelbanter.com/excel-programming/284607-auto_open-on_open.html)

Nathan Gutman

Auto_open or On_open

What is the difference between Auto_open and On_open?
Where can I find a written explanation?
Thanks,
Nathan

John Green[_3_]

Auto_open or On_open

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.

--

John Green - Excel MVP
Sydney
Australia

"Nathan Gutman" wrote in message ...
What is the difference between Auto_open and On_open?
Where can I find a written explanation?
Thanks,
Nathan

All times are GMT +1. The time now is 10:02 AM.