workbook protection with password locking vba

[Bill Rockenbach]

I use activworkbook.protect password:="MyPassword" , save and close the workbook. When I reopen it the workbook opens as if there were no macros. No messages.
I can open the vb editor but the macros are not enabled. Just loaded my 2007 excel on a new dell laptop when this problem started.

Any ideas why this is happening?

Thanks

 

[Alex Blakenburg]

If you changed from pre-2007 to 2007 or when you saved it with the password did you by any chance do a save as and pick .xlsx ?

 

[Bill Rockenbach]

Thanks for the thought, but the file was always saved as an .xlsm.
Actually I did not change Excel versions. I moved Excel 2007 to a new laptop. My old laptop os was Windows 10. The new one runs Windows 11

I have now discovered the problem occurs if protecting the workbook using the ribbon if I set a password.
I think it may be Windows 11 Defender that is cusing the problem and my research tells me you can't shut it off completely even if you load your own anti visus software.

 

[Alex Blakenburg]

I'm afraid I haven't installed Windows 11 yet, so I don't know anything about it having any issues with Excel.
Leila Gharani has done a youtube video on Windows 11 so I gather she is not having any isssues with it, although it could also be that she hasn't tried the exact scenario that you are referring to.
I don't know if any of your issue relates to the fact the that 2007 is getting quite old now and if combining it with Windows 11 is causing any compatibility issues.
This article indicates compatibility may be an issue:
Will your Microsoft Office work on Windows 11?
Extract:-
“NOT supported on Windows 11 is Office 2013 or earlier versions of Office like Office 2010 and Office 2007.
……………
That doesn’t mean those versions of Office won’t work, just that Microsoft doesn’t recommend it and won’t help if you try.”

 

[Bill Rockenbach]

Thanks again
Yes, I thought about age. I have an Excel 2016 professional + I'm going to load in a couple days to see if that helps