Registration: Jun 13, 2021

Comments: 3

Total submitted: 113

Md. Abdul Kader

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.

Lives in

Dhaka, Bangladesh.

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.

Latest Posts From Md. Abdul Kader

How to Sort by Date and Time in Excel (4 Useful Methods)

Let’s have a look at our sample dataset. Here, the Order ID of products is given along with their Delivery Date, Delivery Time, and Price. We’ll sort ...

Md. Abdul Kader Jun 16, 2024

READ MORE +

How to Apply Multiple Filters in Excel: 6 Methods

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits Number and ...

Md. Abdul Kader Apr 16, 2024

READ MORE +

Dynamic Range for Multiple Columns with Excel OFFSET

A dynamic range expands automatically when you update the raw data in the range. In this article, we’ll discuss the ways to apply the OFFSET function in a ...

Md. Abdul Kader Jun 9, 2024

READ MORE +

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Download the Practice Workbook Finding Sum of Last 5 Values.xlsm 5 Simple Methods to Sum Last 5 Values in a Row in Excel We have a dataset that ...

Md. Abdul Kader Aug 4, 2024

READ MORE +

How to Compare Text in Two Columns in Excel

For illustration, we will use following sample dataset containing two lists of items. Method 1 - Comparing Text in Two Columns For Matches in Rows ...

Md. Abdul Kader May 22, 2024

READ MORE +

Reference Operator in Excel [Basics + Special Uses]

It is highly unlikely that you'd be an Excel user without having heard of reference operators. We use these essential operators frequently. And this is the ...

Md. Abdul Kader Nov 11, 2025

READ MORE +

Excel SUMPRODUCT Function Based on Date Range (7 Examples)

An Introduction to the SUMPRODUCT Function This section is mainly for beginners. It'll explain the SUMPRODUCT function and the process of entering the ...

Md. Abdul Kader Apr 30, 2024

READ MORE +

How to Find the Lowest Value with Criteria in Excel – 7 Methods

This is the sample dataset. Method 1 - Combine Excel MIN & IF Functions to Get the Lowest Value 1.1. Single Criteria To get ...

Md. Abdul Kader Aug 6, 2024

READ MORE +

How to Increment Month by 1 in Excel (8 Handy Ways)

We have a dataset of dates in the cell range B5:B16. We will calculate the 1-month increment of the given dates. Method 1 - Use the AutoFill Option ...

Md. Abdul Kader Jun 16, 2024

READ MORE +

How to Add a 1 in Front of Numbers in Excel (7 Methods)

Method 1 - Using Ampersand Operator The ampersand operator is used to combine or merge two or more cells in Excel. In this method, we will use this ...

Md. Abdul Kader May 17, 2024

READ MORE +

How to Apply SUMIF with Multiple Ranges in Excel

In the sample dataset, we want to get the total price of Apples by adding the price in the January, February, March and Discount columns using the SUMIF ...

Md. Abdul Kader Jul 6, 2024

READ MORE +

Sum Values Based on Date in Excel (4 Ways)

Here's a sample dataset that will be used to explain the concept of sum values based on dates in Excel. It's a simple sales table with the date of the sale and ...

Md. Abdul Kader Apr 16, 2024

READ MORE +

Excel COUNTIF with Greater Than and Less Than Criteria

Download the Practice Workbook COUNTIF Greater than and Less than.xlsx 6 Examples of Using COUNTIF to Count Cells in Excel for Greater Than ...

Md. Abdul Kader Jun 13, 2024

READ MORE +

How to Round to Nearest 100 in Excel (6 Quickest Ways)

As shown in the following figure, we have the unit price for each Product ID. Let's round the unit prices to the nearest 100. Method 1 - Using the ...

Md. Abdul Kader Jun 15, 2024

READ MORE +

How to Split One Cell into Two in Excel (5 Useful Methods)

We have a dataset where column B consists of full names. We have to split the cells of column B into two columns, e.g., first name and last name. ...

Md. Abdul Kader Jun 28, 2024

READ MORE +

Browsing All Comments By: Md. Abdul Kader

Md. Abdul Kader May 10, 2023 at 3:03 PM

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

hz = InputBox("enter your password")
hz1 = InputBox("repeat password")

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.Unprotect Password:="1234" 'Replace the password if you want
        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.Unprotect Password:="1234" 'Replace the password if you want
        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.

Reply
Md. Abdul Kader Jan 25, 2023 at 4:23 PM

Hello Michael,
Please specify your problem in detail or send the excel file via [email protected] email address.
Reply
Md. Abdul Kader Oct 4, 2022 at 11:26 AM

Dear Deka,
It’s nice to hear from you with such wonderful appreciation. I myself always try to represent Excel applications in a more user-friendly way. And we, the ExcelDemy team, are working as a one-stop Excel solution provider.
Thanks, and take care of yourself. Goodbye!
Md. Abdul Kader
Editor, ExcelDemy.