List and add days of months in a set period using VBA in Microsoft Excel

In this article, we will create a macro to list months between the defined period and also number of days in that particular month. It will also dis...

Distribute Data from a List of the day to day sheets using VBA

  In this article, we will create a macro to arrange data day-wise on multiple sheets. Raw data for this article consists day-wise sales data o...

Enter the holiday according to the Table in the holiday-list using VBA

Question: I have the EmployeeName, the HolidayStart and the HolidayEnd in a Worksheet. How can I color the holidays of each employee in the following...

Check if a VBProject is protected using VBA in Microsoft Excel

With the function below you can check if a VBProject is protected before you try to edit the project: Function ProtectedVBProject(ByVal wb As Workboo...

Show the time in hh:mm.sss format using VBA

In this article, we will create a macro to format the time in hh:mm.sss format. Raw data for this example consists of certain time values in column E...

Cell protection only for formulas using VBA in Microsoft Excel

In this article, we will use change event of worksheet to protect cells which contain formulas. Raw data consists of employee sales data, which inclu...

Create day sheets of a month without weekends and holidays using VBA

In this article, we will create a macro to create a sheet for each weekday for the specified month of the specified year excluding all the dates speci...

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube