MD. ABDUL KADER is an engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SWM, GIS, RS, and SPSS. He holds a B.Sc in Urban & Regional Planning from Chittagong University of Engineering and Technology and has shifted to become a content developer. In this role, he crafts technical content centred around Excel and VBA. Outside the professional realm, catch him immersed in books, exploring new places during travels, and watching movies.

## Designation

Team Leader at ExcelDemy in SOFTEKO.

## Education

B.Sc in Urban & Regional Planning, Chittagong University of Engineering and Technology

## Expertise

SWM, GIS, RS, SPSS, MS Excel, PowerQuery, PowerPivot & VBA

## Experience

• Technical Content Writing
• Team Management

## Summary

• Currently working as Team Leader of ExcelDemy.
• He started writing technical content for Excel & VBA for ExcelDemy in 2021.

## Excel VBA: Create a UserForm Image from a Worksheet – 3 Examples

What Is a VBA UserForm? A UserForm is a dialog box that provides an interactive interface. Example 1 - Using the Copy Pasting Tool You have an ...

## How to Find and Replace within Selection in Excel (7 Methods)

Our sample dataset contains the sales report of some Items along with the relevant Sales Rep. Quantity, Unit Price, and Sales for each item are also provided. ...

## How to Use Dynamic Range for Last Row with VBA in Excel (3 Methods)

Why Do You Need a Dynamic Range We have a simple dataset with Quantity, Unit Price, and Sales of some Items. We want to find the average, sum, maximum value, ...

## VLOOKUP Date Range and Return Value in Excel: 4 Methods

Let’s introduce today’s dataset where the name of the Items is provided along with Order Dates, Unit Price, Quantity and Sales. Method 1 - VLOOKUP a ...

## How to Change Date Format in Pivot Table in Excel

Let’s introduce today’s dataset where Sales of some Product Categories is provided along with an Order Date and corresponding States. Creating a Pivot ...

## How to Count Unique Values in a Filtered Column in Excel (5 Methods)

Dataset Overview In our dataset, we have information on the Quantity and Sales of various Product Categories, along with Order Dates and corresponding States. ...

## How to Convert Number to Text without Scientific Notation in Excel

In Excel, if you input a number with 15 or more digits, although the number is stored in number format as usual, it is displayed by default in scientific ...

## How to Combine Cells into One with Line Break in Excel: 5 Methods

Method 1 - Using the Ampersand Operator and CHAR Function Assuming that you want to get combined information by merging two or more cells. The following ...

## How to Lock Multiple Cells in Excel – 6 Methods

This is the sample dataset.   How to Lock Multiple Cells to Protect Them    Method 1 - Using the Format Cells Option Step 1 - ...

## How to Apply Conditional Formatting in Excel If Another Cell Is Blank: 5 Methods

In the dataset below, the Sales Report for January is provided, and some cells are blank. Method 1 – Using a Simple Formula Steps: Select ...

## [Fixed] Excel Print Error Not Enough Memory

You might receive the error message below when trying to print an Excel file (.xlsx or .xlsm). There are several possible reasons for this error, such as ...

## How to Delete a Row Using Macro If a Cell Contains 0 in Excel (4 Methods)

The dataset below shows the Number of Visits, the Names of the Sites, and the Dates. Some sites have a cell value (Number of Visits) of 0. In such a situation, ...

## How to Count Duplicates in Two Columns in Excel (8 Methods)

Column B depicts the List of US Companies by Revenue (List-1) while column D shows the List of US Companies by Profit (List-2). We’ll count the number of ...

## How to Copy Rows in Excel with Filter (6 Fast Methods)

In this article, we will demonstrate 5 ways to copy filtered rows in Excel. We'll use the dataset below (B1:F16 cell range) to illustrate our methods. For ...

## How to Autofilter and Copy Visible Rows with Excel VBA

The dataset below has 5 columns displaying a Site's name, Category, Date, Platform, and Number of Visits for each site. Method 1 – AutoFilter and Copy ...

1. Hello EAC,
Thanks for your question. Most likely, you need to put a not equal sign (<>) inside the If…Then statement of your second code. So, the corrected second code will be as follows-

``````Sub block()
Dim hz As String
Dim hz1 As String

If hz <> hz1 Then
MsgBox "The repeated password is not identical!", vbExclamation
hz = ""
hz1 = ""
Else
Columns("D:F").Select
Selection.Locked = False
Range("D8:F12").Select
Selection.Locked = True
Range("a1").Select
ActiveSheet.Protect hz
End If
End Sub``````

However, your used three codes are quite messy. I would like to suggest that you can use the following code to lock a specific cell range in all worksheets of your Excel file.

``````Sub Lock_CellRange_AllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Range("D8:F12").Locked = True 'Replace the cell range
ws.Protect Password:="1234", UserInterfaceOnly:=True 'Replace the password with the actual password for the workbook if it is protected
Next ws
End Sub``````

Again, try this code to unlock the specific cell range in all worksheets.

``````Sub Unlock_CellRange_AllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Range("D8:F12").Locked = False 'Replace the cell range
ws.Protect Password:="1234", UserInterfaceOnly:=True 'Replace the password with the actual password for the workbook if it is protected
Next ws
End Sub``````

I hope these will work! Moreover, you can follow lock and unlock cells using VBA to explore more efficient methods.

2. Hello Michael,