Excel VBA Unprotect Sheet Without Password in 2 Easy Steps

In this Excel VBA Unprotect Sheet Without Password Tutorial, you learn how to unprotect a sheet without password using Excel macros.

This Excel VBA Unprotect Sheet Without Password Tutorial is accompanied by an Excel workbook with the data and VBA code I use when describing the step-by-step process below. Get this example workbook (for free) by clicking the button below.

The VBA code in the Excel workbook that accompanies this Excel VBA Unprotect Sheet Without Password Tutorial is (always) stored in the Visual Basic Editor (VBE). If you don't know how to work with the VBE, I suggest you read my Visual Basic Editor (VBE) Tutorial. I link to this Tutorial in the Related Excel Macro and VBA Training Materials and Resources Section below.

Table of Contents

The following Excel Macro and VBA Tutorials may help you better understand and implement the contents below.

Tutorials about general macro and VBA constructs and structures:
- Tutorials for Beginners:
  - Excel Macros: Click here to open.
  - Excel VBA: Click here to open.
- Enable macros in Excel: Click here to open.
- Work with the Visual Basic Editor (VBE): Click here to open.
- Create Sub procedures: Click here to open.
- Refer to objects (click here to open), including sheets (click here to open).
- Work with:
  - Methods: Click here to open.
  - Data types: Click here to open.
  - Loops: Click here to open.
Tutorials with practical VBA applications and macro examples:
- Activate workbook: Click here to open.
- Create new workbook: Click here to open.
- Open workbook: Click here to open.
- Delete sheet: Click here to open.

This Excel VBA Unprotect Sheet Without Password Tutorial is part of a more comprehensive series of Excel VBA Protect or Unprotect Sheet Tutorials.

Excel VBA Protect Sheet Without Password in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet with Password in 2 Easy Steps: Click here to open.
Excel VBA Unprotect Sheet with Password in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet Allow Filter in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet Allow Select Locked Cells in 4 Easy Steps: Click here to open.

You can find more Excel and VBA Tutorials in the organized Tutorials Archive: Click here to visit the Archives.

If you want to learn how to automate Excel (and save time) by working with macros and VBA, you may be interested in the following Premium Excel Macro and VBA Training Materials:

Premium Courses at the Power Spreadsheets Academy: Click here to open.
Books at the Power Spreadsheets Library: Click here to open.
VBA Cheat Sheets: Click here to open.

If you want to save time when working with macros and VBA, you may be interested in AutoMacro: Click here to learn more about AutoMacro (affiliate link). AutoMacro is an add-in for VBA that installs directly into the VBE. Depending on the version, AutoMacro comes loaded with:

Code generators.
An extensive code library.
The ability to create your own code library.
Advanced coding tools.

If you need consulting services, you may want to consider working with ExcelRescue. ExcelRescue is my usual suggestion for people who (like you) may need help with Excel tasks/projects: Click here to visit ExcelRescue (affiliate link).

The VBA Unprotect Sheet Without Password Snippet Template/Structure

The following is the VBA unprotect sheet without password snippet template/structure I explain (step-by-step) in the Sections below.

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/

'Sheet is a worksheet
WorkbookObjectReference.WorksheetObjectReference.Unprotect

'Sheet is a chart sheet
WorkbookObjectReference.ChartObjectReference.Unprotect

The Example Before VBA Unprotect Sheet Without Password

The example workbook has a single (empty) worksheet.

The name of the example worksheet is “Unprotect Sheet no Password”.
This is the sheet the VBA unprotect sheet without password example macro I create (by following the step-by-step process below) works with. In other words: The VBA unprotect sheet without password example macro unprotects this sheet without a password.

The image below displays the example worksheet before I execute the VBA unprotect sheet without password example macro.

Before I execute the VBA unprotect sheet without password example macro, the example worksheet is protected without a password. Notice the Unprotect Sheet button (inside the Protect group of commands) in the Excel Ribbon (indicating the example worksheet is (currently) protected).

Example Excel workbook before VBA unprotect sheet without password example macro

Step 1: Refer to Sheet

Refer to the sheet you want to unprotect without password.

In other words: Create a VBA expression that returns an object representing the applicable sheet (you want to unprotect without a password). As a general rule: Work with 1 of the following objects:

A Worksheet object, representing a worksheet.
A Chart object, representing a chart sheet.

Consider explicitly including the following references to create a fully qualified object reference returning the applicable Worksheet (representing a worksheet) or Chart (representing a chart sheet) object:

A reference to the applicable workbook. The following VBA constructs (among others) may return a Workbook object:
- The Application.ThisWorkbook property.
- The Application.Workbooks and Workbooks.Item properties.
- The Application.ActiveWorkbook property.
A reference to the applicable worksheet or chart sheet. The following VBA constructs (among others) may return a Worksheet or Chart object:
- The Workbook.Sheets and Sheets.Item properties.
- The Workbook.Worksheets and Worksheets.Item properties.
- The Workbook.Charts and Charts.Item properties.
- The Application.ActiveSheet property.
- The Workbook.ActiveChart property.

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/

'Sheet is a worksheet
WorkbookObjectReference.WorksheetObjectReference

'Sheet is a chart sheet
WorkbookObjectReference.ChartObjectReference

The unprotect sheet without password VBA code template/structure you learn in this Tutorial assumes the sheet you want to unprotect is (currently) protected without a password.

Step 1 Example

Refer to the worksheet named “Unprotect Sheet no Password” inside the workbook where the procedure is stored.
Work with the following VBA constructs to obtain a Worksheet object representing this worksheet:
- The Application.ThisWorkbook property: ThisWorkbook.
- The Workbook.Worksheets and Worksheets.Item properties: Worksheets(“Unprotect Sheet no Password”).

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/
ThisWorkbook.Worksheets("Unprotect Sheet no Password")

Step 2: Unprotect Sheet Without Password

Call the applicable version of the Unprotect method:

Worksheet.Unprotect, if unprotecting a worksheet.
Chart.Unprotect, if unprotecting a chart sheet.

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/

'Sheet is a worksheet
WorkbookObjectReference.WorksheetObjectReference.Unprotect

'Sheet is a chart sheet
WorkbookObjectReference.ChartObjectReference.Unprotect

Step 2 Example

Considering the Worksheet object reference I created in step #1.

'Source: https://powerspreadsheets.com/
'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/
ThisWorkbook.Worksheets("Unprotect Sheet no Password").Unprotect

The full VBA unprotect sheet without password example macro is as follows:

Sub UnprotectSheetWithoutPassword()
    'Source: https://powerspreadsheets.com/
    'More information: https://powerspreadsheets.com/unprotect-sheet-without-password/
    
    'Do the following:
        'Step 1: Refer to the "Unprotect Sheet no Password" worksheet in this workbook
        'Step 2: Unprotect the worksheet
    ThisWorkbook.Worksheets("Unprotect Sheet no Password").Unprotect

End Sub

The GIF below illustrates the effects of using the VBA unprotect sheet without password example macro.

Notice how:

The Unprotect Sheet button (inside the Protect group of commands) in the Excel Ribbon (indicating the example worksheet is (currently) protected);
Is replaced by the Protect Sheet button (indicating the example worksheet is now unprotected) when I execute the VBA unprotect sheet without password example macro.

Example: Unprotect Excel sheet without password using VBA macros

Download the VBA Unprotect Sheet Without Password Example Workbook

This Excel VBA Unprotect Sheet Without Password Tutorial is accompanied by an Excel workbook with the data and VBA code I use when describing the step-by-step process above. Get this example workbook (for free) by clicking the button below.

The following Excel Macro and VBA Tutorials may help you better understand and implement the contents above.

Tutorials about general macro and VBA constructs and structures:
- Tutorials for Beginners:
  - Excel Macros: Click here to open.
  - Excel VBA: Click here to open.
- Enable macros in Excel: Click here to open.
- Work with the Visual Basic Editor (VBE): Click here to open.
- Create Sub procedures: Click here to open.
- Refer to objects (click here to open), including sheets (click here to open).
- Work with:
  - Methods: Click here to open.
  - Data types: Click here to open.
  - Loops: Click here to open.
Tutorials with practical VBA applications and macro examples:
- Activate workbook: Click here to open.
- Create new workbook: Click here to open.
- Open workbook: Click here to open.
- Delete sheet: Click here to open.

This Excel VBA Unprotect Sheet Without Password Tutorial is part of a more comprehensive series of Excel VBA Protect or Unprotect Sheet Tutorials.

Excel VBA Protect Sheet Without Password in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet with Password in 2 Easy Steps: Click here to open.
Excel VBA Unprotect Sheet with Password in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet Allow Filter in 2 Easy Steps: Click here to open.
Excel VBA Protect Sheet Allow Select Locked Cells in 4 Easy Steps: Click here to open.

You can find more Excel and VBA Tutorials in the organized Tutorials Archive: Click here to visit the Archives.

If you want to learn how to automate Excel (and save time) by working with macros and VBA, you may be interested in the following Premium Excel Macro and VBA Training Materials:

Premium Courses at the Power Spreadsheets Academy: Click here to open.
Books at the Power Spreadsheets Library: Click here to open.
VBA Cheat Sheets: Click here to open.

Code generators.
An extensive code library.
The ability to create your own code library.
Advanced coding tools.