Multiple Private subs

[LouiseH24]

Hiya,

I am new to the forum!

I am having an issue with my code that I have stored in the This Workbook Object - I have put together a Private Sub Workbook_Open and a Private Sub Workbook_SheetChange. Before it has finished running through the code in the workbook open sub, it seems to jump into the code for the workbook sheet change sub (seems to be each time it hits the Then part of a If condition).

Is this a general issue in VBA or is this something to do with the way I have written my code?

Thanks for your time.

Lou

[StephenR]

I expect something in the Open code affects a sheet. Can you post your code?

[LouiseH24]

Sure thing:

Please Login or Register  to view this content.

I apologise if the code seems crude - I am new to private subs

[StephenR]

Try adding this line after your d=4 line and turning it back on at the end:

Please Login or Register  to view this content.

Btw you can dispense with most Selects, e.g.

Please Login or Register  to view this content.

[LouiseH24]

Brilliant - thank you ever so much, I will give this a try

[LouiseH24]

Perfect this seems to have worked!!