This example protects the active worksheet and then determines if columns can be inserted on the protected worksheet, notifying the user of this status. ' Check the ability to insert columns on a ...

KBreaker for Excel is a local desktop tool that unlocks password-protected worksheets in .xlsx files — without requiring the actual password. It works by injecting ...

I used this method on an Outlook form previously. Not sure if Excel has the same inspector object, but ... worth a try.