I recently came across this great little macro to remove a forgotten protection password from workbooks or worksheets in Microsoft Excel. Follow this link to the macro goodness.
Came across an interesting Microsoft Excel feature. Usually when you open a spreadsheet and it is in use by another user you’ll get the popup asking to open read only or notify. However, I found a scenario where it wasn’t prompting and just opening the file as a new file. For example if the file isRead more about Excel not prompting to open locked file as read only[…]