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 Find Duplicates in Excel Workbook (5 Methods)

Suppose there are two sheets in the workbook named Sheet1 and Sheet2. Sheet1 represents the employee name with their states while Sheet2 displays the joining ...

Md. Abdul Kader Jun 16, 2024

READ MORE +

Troubleshooting Data Table Issues in Excel (7 Solutions)

Solution 1 - AutoCorrect Settings Data tables in Excel can automatically expand, but sometimes they fail to do so when new data is entered. For ...

Md. Abdul Kader Jul 24, 2024

READ MORE +

How to Use DCOUNTA Function in Excel (5 Examples)

When we need to count the number of non-empty cells in a given database, the Excel DCOUNTA function is the perfect function for the job. In this article, we'll ...

Md. Abdul Kader Aug 1, 2024

READ MORE +

How to Generate Moving Average in Excel Chart: 4 Methods

Method 1 - Generating Moving Average in Excel Chart Select data. Click Insert tabs>Charts ribbon. Click Recommended Charts or any chart option ...

Md. Abdul Kader Jul 6, 2024

READ MORE +

How to Use SIGN Function in Excel (7 Effective Examples)

Sometimes, we need the sign of any real number. Regarding the demand, Excel provides the SIGN function which returns the sign of number quickly. In this ...

Md. Abdul Kader Nov 11, 2025

READ MORE +

How to Use SHEETS Function in Excel (5 Useful Examples)

Introduction to Excel SHEETS Function The SHEETS function is a built-in function added in the Excel 2013 version which returns the number of worksheets in a ...

Md. Abdul Kader Jul 19, 2024

READ MORE +

How to Use YIELD Function in Excel (4 Effective Examples)

In some cases, we have to calculate the yield based on a security or purchased bonds. Mathematically, we need to solve a complex equation for calculating the ...

Md. Abdul Kader Nov 11, 2025

READ MORE +

How to Use the Excel RANK Function – 6 Examples

This is an overview. Introduction to the RANK Function in Excel Objective: The RANK function returns the position of a given number in a ...

Md. Abdul Kader Aug 8, 2024

READ MORE +

How to Use the ROUND Function in Excel (9 Examples)

Introduction to ROUND Function Function Objective The ROUND function is a powerful tool for rounding numbers based on a specified number of digits. Whether ...

Md. Abdul Kader Jul 15, 2024

READ MORE +

How to Use the INT Function in Excel – 8 Examples

The Excel INT Function: Summary A decimal number can be represented as an integer using the INT function, which rounds it down to the lowest integer ...

Md. Abdul Kader Aug 3, 2024

READ MORE +

How to Use the ROW Function in Excel (8 Examples)

Overview of the Excel ROW Function Description The ROW function returns the row number for a given reference. The reference may be a cell or ...

Md. Abdul Kader Jul 1, 2024

READ MORE +

How to Use the NOT Function in Excel – 8 Examples

This is an overview: The Excel NOT Function The NOT function reverses (opposite of) a Boolean or logical value. If you enter TRUE, the ...

Md. Abdul Kader Aug 12, 2024

READ MORE +

How to Use TRUE Function in Excel (10 Ideal Examples)

The TRUE function has a special type of compatibility in returning results based on logical conditions. TRUE Function in Excel (Quick View) ...

Md. Abdul Kader Jun 21, 2024

READ MORE +

How to Use WEEKDAY Function in Excel (with 8 Examples)

Excel WEEKDAY Function: Syntax & Arguments Syntax =WEEKDAY(serial_number, ) Return Values 0 to 7 (in numbers) Arguments ...

Md. Abdul Kader May 6, 2024

READ MORE +

How to Use the MINUTE Function in Excel – 6 Examples

The Excel MINUTE Function Summary The MINUTE function returns the number of minutes in a given time value. For example, if the time value is “10:30 ...

Md. Abdul Kader Aug 14, 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.