Recovering a VBA protect password
I wrote a database in 2009/2010 in 2007. I migrated it to 2010, changed it to an accdb and password protected the VBA. In 2017, I left the company, handed over all of my passwords, and left my code in another's hands. In Sept 2021, they asked me to please come back, I did, and the password to the DB I am trying to recover was lost. I have tried using HxD, which doesn't work with accdb. How can I recover the password?
SharePoint won't work with Excel encryption
Our Finance team has password protected many of their files, as they contain salaries and other sensitive information. However, every time they open one of these files, AutoSave is disabled, and they have to constantly save over the top of the existing file (ie, they can't just hit Save). This is a complete nightmare for them, and they want to abandon SharePoint because of this. Obviously, we can't be the only organization that uses SharePoint and Excel together who happen to have passwords on the files. Is removing the passwords the only way to stop this? They're wasting time and reckon that a 3-minute job now takes them half and hour because they're constantly having to go through the 'save as' dialog box everytime they make a change and want to save.