How to Protect/Unprotect all Worksheets with VBA in Microsoft Excel 2010

In this article, you will learn how to protect & unprotect all the sheets with VBA code.   To open the VBA editor screen, follow the below ...

How to Popup Text Box with a Single Click Using VBA in Microsoft Excel 2010

In this article, you will learn how to pop-up text with a single click using VBA code.   Let us understand with an example: To view a textbo...

How to Open Password Protected Excel Workbook in Microsoft Excel 2010

In this article, you will learn how to open password protected Excel workbook. If you have to work on a workbook that is password protected. Here i...

How to Get Name of Day from Date Using VLOOKUP in Microsoft Excel 2010

In this article, we will learn How to Get Name of Day from Date Using VLOOKUP in Microsoft Excel 2010. In this article, we will learn about how...

How to Get Multiple Values from Same Criteria in Microsoft Excel 2010

In this article, we will learn How to Get Multiple Values from Same Criteria in Microsoft Excel 2010. Its easy to lookup for a value with one uniqu...

How to Get Color of the Cell Using VBA in Microsoft Excel 2010

In this article, you will learn how to get color of the cell using VBA code.   We need to follow the below steps to launch VB editor.   ...

How to Find Bold Cell using VBA in Microsoft Excel 2010

In this article, you will learn how to find bold cell using VBA. We will use VBA code to create UDF function to find out the bold cells.   Clic...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.