On Error run Private Sub Workbook_Open() <-- is this possible?

[JasperD]

Hi guys and gals,

as in the topic : On Error run Private Sub Workbook_Open() <-- is this possible?
Thanks for any reply!

[sktneer]

Private Sub Workbook_Open() will only execute when you open your workbook. You can achieve this by writing another sub routine like Private Sub MyCode() where you can place the code of workbook_open by copying the code between Private Sub Workbook_Open() and End Sub lines and placing it between the lines Private Sub MyCode() and End Sub. Then you can call Mycode if an error occurs in your another sub routine.

Like this.....

Please Login or Register  to view this content.

[JasperD]

I was afraid so....
Thanks for your feedback!

[romperstomper]

That's not correct. Workbook_Open is a routine like any other. As it has Private scope you have to use Run to call it but you can't do it in one line as an On Error statement - you would have to have a goto statement and run it from there:

Please Login or Register  to view this content.

for example.

Having said that, if you want to call the same code from two locations, you should put it into a separate routine and call that from both locations.

[JasperD]

Hi Rory,

awesome, thanks!