Macros & Excel VBA

Excel VBA: Unprotect Workbook with Password (7 Practical Examples)

This article illustrates how to unprotect a workbook that is protected with a password using VBA in Excel with 7 suitable examples. Excel allows the ...

Excel VBA: Protect Sheet with Password and Allow Filter

In this article, I’ll show you how can protect an Excel sheet with a password and also allow the filter there using VBA. Excel VBA: Protect ...

Macro to Convert Excel to Pipe Delimited Text File (3 Methods)

Implementing VBA macro is the most effective, quickest and safest method to run any operation in Excel. This article will show you how to convert ...

Excel VBA to Lock Cells without Protecting Sheet (4 Ideal Examples)

Generally, we protect the whole worksheet to lock cells in Excel. But we can also lock cells without protecting a sheet in Excel with VBA. Today, we ...

How to Protect Specific Columns Using VBA in Excel

In all types of day-to-day use of Excel, we often need to lock certain columns and rows so that other people or users can't change the contents of ...

Excel VBA: Unprotect All Sheets (4 Suitable Examples)

This article illustrates 4 suitable examples to unprotect all sheets in a workbook in Excel using VBA. Excel allows the feature to protect sheets ...

Excel VBA: Read a Text File Line by Line (6 Related Examples)

In this article, you will learn 6 related examples to read a text file line by line using VBA code in Excel. Download Practice Workbook You ...

How to Apply Macro to Send Email from Excel with Attachment

While working with Exel files in our day-to-day lives, we often need to send an Email containing the file as an attachment. In this article, I’ll ...

Excel VBA: Unprotect Workbook without Password (2 Examples)

In this article, we will show you 2 examples of how to Unprotect Excel Workbook without a Password using VBA. We have got a Protected Workbook with a ...

Excel VBA: Protect Workbook with Password (3 Quick Tricks)

While working with Microsoft Excel, sometimes we need to protect our dataset for the convenience of our work. Basically, we may need to protect ...

How to Fill Blank Cells with Value Above in Excel VBA (3 Easy Methods)

In this article, I’ll show you how you can fill the blank cells within a range in Excel with the value available immediately above using VBA. ...

VBA Code to Convert Text File to Excel (7 Methods)

Sometimes we have loads of data stored in text files. If we can transfer the contents from those text files to Excel workbook in an organized and ...

Excel Macro: Save as PDF with Date in Filename (4 Suitable Examples)

In this article, I’ve discussed 4 suitable examples to save an Excel file as a PDF using the Macro with the date in the filename. Download ...

Excel VBA: Replace Character in String by Position (4 Effective Ways)

This article illustrates how to replace a character in a string by position using VBA in Excel with 4 effective approaches. We’ll use Excel’s ...

How to Calculate Time Difference in Excel VBA (2 Methods)

While working with times with VBA in Excel, we often have to calculate the time difference between two times. In this article, I’ll show you how you ...

ExcelDemy
Logo