Explain - Private Sub Workbook_Open()

[hedge]

Hi,

can some explain what this code is doing

Please Login or Register  to view this content.

I mainly don't understand the

Please Login or Register  to view this content.

Thanks,

[shg]

When that sub appears in the ThisWorkbook module, it runs when the workbook opens -- if macros are enabled. Workbook_Open is one of a family of events that Excel raises to allow code to process the event.

The Application.Volatile line makes no sense to appear there.