Private Sub Workbook_Open() Vs Public Sub Auto_Open()

[Faridwahidi]

Hi,

Can anyone explain the differences between both command? Which is better ? I found it have the same function

I have used Schedule tasks to open workbook and Auto_Open() running as usual.

[HaHoBe]

Hi, Farid,

AFRAIR Auto_Open is from "old times" while Workbook_Open was introduced with Excel97 and should be used from then on due to the changes in the event section of the VBA-code. Workbook_Open is called prior to Auto_Open. IŽd recommend to use Workbook_Open in ThisWorkbook and just remember Auto_Open in a standard module but not use that command any more (maybe MS decides one day to stop the support of that function although I pretty much doubt that with all the other functions still being supported).

Ciao,
Holger

[Faridwahidi]

Hi Holger,

Many thanks for clarification

[romperstomper]

The main difference, besides the location of the code, is that when you open a workbook in code, the Auto_Open won't automatically run - you have to call it explicitly - whereas Workbook_Open will run unless you disable events.

[joeu2004]

[.... incorrect comment deleted ....]

[romperstomper]

Please review what I wrote - emphasis added below:

when you open a workbook in code, the Auto_Open won't automatically run

[joeu2004]

Please review what I wrote - emphasis added below:

you open a workbook in code, the Auto_Open won't automatically run

That you did! And it is indeed correct. My bad! I removed my incorrect comment.

[Faridwahidi]

Hi Rory,

Thanks.

[romperstomper]

Thanks.