VBA Modules/Macros wont load on startup

[SpartanGhost505]

Hello all,

I was hoping I could gain some advice, I have some modules such as a welcome message, and another one that disables right clicking, which usually work great.

When they're locked into a password protected sheet, they refuse to work or automate on opening Excel? If i remove the password and reopen the spreadsheet, all of it kicks back in and works.

Can anyone suggest anyway around this as the documents need to be protected with password (not protected worksheet...the whole document requires a password on entry)

Thanks in advance!

 

[GlennUK]

Describe your actions in detail ... it's hard to understand what you mean? Also, show your macros, or at least the Welcome message one. Do you get any error messages?

 

[Jaafar Tribak]

Are those "modules" being called automatically upon opening the workbook in the Workbook_Open event ?
If so, can you try using the Workbook_Activate event instead and see what happens.