Workbook protection in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to protect the workbook structure in Excel using VBA.

Excel

ThisWorkbook.Protect [1]:=True

Drag options to blanks, or click blank then click option'

APassword

BStructure

CWindows

DReadOnly

Attempts:

3 left

💡 Hint

Common Mistakes

Using Password instead of Structure

Using Windows which protects window size, not sheets

Using ReadOnly which is unrelated here

Use Structure:=True to protect the workbook structure, preventing adding, deleting, or moving sheets.

2fill in blank

medium

Complete the VBA code to unprotect the workbook with a password.

Excel

ThisWorkbook.Unprotect Password:= [1]

Drag options to blanks, or click blank then click option'

A"mypassword"

Bmypassword

C'mypassword'

Dpassword

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the password

Using single quotes which VBA does not recognize for strings

Using a variable name without defining it

The password must be a string literal enclosed in double quotes in VBA.

3fill in blank

hard

Fix the error in the code to protect workbook windows and structure.

Excel

ThisWorkbook.Protect Structure:=True, [1]:=True

Drag options to blanks, or click blank then click option'

ASheets

BPassword

CReadOnly

DWindows

Attempts:

3 left

💡 Hint

Common Mistakes

Using Password without a value

Using ReadOnly which is unrelated

Using Sheets which is not a valid property here

The correct property to protect workbook windows is Windows.

4fill in blank

hard

Fill both blanks to protect the workbook with a password and structure protection.

Excel

ThisWorkbook.Protect [1]:=True, [2]:="secure123"

Drag options to blanks, or click blank then click option'

AStructure

BPassword

CWindows

DReadOnly

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping password and structure properties

Using Windows instead of Structure

Not using quotes around the password

Use Structure:=True to protect sheets and Password:="secure123" to set the password.

5fill in blank

hard

Fill all three blanks to protect the workbook with a password, unprotecting structure but protecting windows.

Excel

ThisWorkbook.Protect [1]:="letmein", [2]:=False, [3]:=True

Drag options to blanks, or click blank then click option'

APassword

BStructure

CWindows

DReadOnly

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up Structure and Windows values

Not using quotes for the password

Using ReadOnly which is not valid here

Use Password to specify the password, Structure:=False to unprotect sheets, and Windows:=True to keep windows protected.