4 articles Tips and tricks

Recover or break vba password for Microsoft Excel file

break vba password microsoft excel recover2

Sometimes I need to recover or break the VBA password for an excel file because I build some code inside excel files and protect the file with a vba password just to keep my colleagues from ruining the code behind the excel reports. There are times when I don’t pay attention to the password thinking…

 

Useful Excel keyboard shortcuts tutorial

Excel Shortcuts

Work with excel as efficient as you can using keyboard shortcuts instead of clicking the mouse. If you take one hand from the keyboard to click the mouse you loose precious time and energy. All you need to know is key shortcuts that do certain action you used to do with the mouse. Excel useful…

 

Hide an excel sheet so that nobody can see it

To hide an excel sheet so nobody could see it, like the results of a database query when you want just to show a summary based on it, select that sheet and do the following: Making an excel sheet very hidden Right click on the sheet name View Code In the VBA project window that…

 

Find and delete duplicates in Excel

find highlight remove delete duplicates excel

In order to find and remove duplicates or just highlight them in an complex and messy Excel spreadsheet be prepared to work hard or just smart and elegant. Too many times we end up with an extralarge Excel file that contains some very complex information and a lot of duplicates that we need to find…