Macros & Excel VBA Archives - Page 2 of 43

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

May 18, 2022 Macros & Excel VBA

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

May 18, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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

May 18, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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

May 17, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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)

May 14, 2022 Macros & Excel VBA

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)

May 16, 2022 Macros & Excel VBA

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)

May 17, 2022 Macros & Excel VBA

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)

May 14, 2022 Macros & Excel VBA

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)

May 12, 2022 Macros & Excel VBA

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)

May 14, 2022 Macros & Excel VBA

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 ...