All About “Developer Tab” in Excel

Hello Excel Developers, To know how to add Developer tab in Excel Ribbon, visit this article. Now let’s go through how to insert and work around basic Form Controls. We will be using “Form Controls” and not “ActiveX Controls” (Under Insert group in Developer Ribbon). The reason being Form Controls are very simple and easy to […]

Share

How to add Developer tab in Excel Ribbon!!

Hello Excel Developers, I hope you must have activated the Developer tab in your copy of Excel by now. If yes, it will appear like below image.   If not yet, Follow this simple steps to activate “Developer Ribbon” How to add Developer tab into Excel 2007 Ribbon? Click the Office Button; Click the Excel Option […]

Share

How to remove protection in workbook/worksheet!

Hello Excelhackers, Many a times you receive a protected file and you desperately want to un-protect it to view the hidden cells and formulas etc. This is very simple with the help of running below macro. password remover macro for EXCEL protected workbook Steps Opening VBA (ALT +F11) Paste the code at above link in Module 1. […]

Share
Access Rights in Excel

Access Rights configuration for users in Excel

Hello Secretive Excel Users, Have you ever wanted to give access to only particular worksheets to some user and hide some worksheets for particular user. Below is the perfect solution you would like to implement. First in step by step with screenshots. Later in Video. Step 1 Create a worksheet called “Access Rights” as below […]

Share

Subscribe for Newsletter