We had an employee leave the company and who we now find has password protected write access to several macros in an important spreadsheet.
When I try to edit the macro normally, I can select the Macro, but all options are then greyed out except the ability to run it. We need to edit it.
I tried to save the spreadsheet to Excel 95 version, but it won't let me with a "VBA Project password protected".
Is there any way to defeat the Excel Macro Password in the Visual Basic Editor?