Workbook_Open event not running on password protected workbook

[Formula11]

Does anyone know how to run the "Workbook_Open" event on password protected workbook?
The code below as an example does not work.
Also, I cannot run a macro once in the workbook as well, Design Mode is always on and the error message is "Because of security settings, macro have been disabled".

Option Explicit

Private Sub Workbook_Open()
    MsgBox "Hi"
End Sub

 

[rlv01]

Check your Trust Center macro settings.

File ->Options ->Trust Center ->Trust Center Settings ->Macro Settings

 

[Formula11]

rlv01, yes I have adjusted these settings, even with"Enable all macros".
Still no good.

 

[yky]

rlv01, yes I have adjusted these settings, even with"Enable all macros".
Still no good.

Strange. It works on my Excel 2010. I even protected both the sheet and workbook. When I opened the workbook, the message box popped up.

 

[Formula11]

OK thanks for advising. I wonder what the issue is with mine.

 

[rlv01]

An 'old school' workaround is to use the auto_open macro.

Private Sub auto_open()
    MsgBox "Hi"
End Sub

Place it in a normal code module

 

[Formula11]

Still no good unfortunately.
For some reason, when I put a password on the workbook, the macros don't run.
The "Design Mode" functionality seems to be greyed out automatically. This is with Office 2007.

 

[Fazza]

what if you fully close (& then re-open) Excel?

 

[Formula11]

Yes I've tried this as well, but still have issues.
Started from scratch with a new workbook as well.