Problem with ThisWorkbook Module: Two Private Sub Workbook_Open()

Hi,

It seem like have two Private Sub Workbook_Open() in the ThisWorkbook Module make both code not working.
I tried to put them both under one Private but not working also. One of the Private has Option Explicit.

Here is the code:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is there a solution to this?

Thanks

Good afternoon DavidRoger

You can only have one Workbook_Open module per file - the same goies for any other event procedure (or any normal module with identical names, really).
The solution is just to merge the two instructions into one file, and they will be executed consecutively, thus :

Please Login or Register  to view this content.

HTH

DominicB

Thanks. It works. No sure why it didn't work before.