Sharing workbooks in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to save the workbook with sharing enabled.

Excel

ActiveWorkbook.SaveAs Filename:="SharedBook.xlsx", [1]:=True

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

AReadOnlyRecommended

BCreateBackup

CShareWB

DPassword

Attempts:

3 left

💡 Hint

Common Mistakes

Using ReadOnlyRecommended instead of ShareWB

Confusing password protection with sharing

Omitting the sharing parameter

The ShareWB parameter enables sharing when saving the workbook.

2fill in blank

medium

Complete the code to allow multiple users to edit the workbook simultaneously.

Excel

ActiveWorkbook.[1] = True

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

ATrackChanges

BEnableAutoSave

CAllowEditRanges

DMultiUserEditing

Attempts:

3 left

💡 Hint

Common Mistakes

Using KeepChangeHistory instead of MultiUserEditing

Confusing AllowEditRanges with multi-user editing

Trying to enable AutoSave for sharing

The MultiUserEditing property allows multiple users to edit the workbook at the same time.

3fill in blank

hard

Fix the error in the code to properly share the workbook.

Excel

ActiveWorkbook.[1] = True

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

AMultiUserEditing

BSharedWorkbook

CShareWorkbook

DSharing

Attempts:

3 left

💡 Hint

Common Mistakes

Using ShareWorkbook instead of MultiUserEditing

Trying to call Add on a non-collection property

Confusing method and property names

The correct property to enable sharing is MultiUserEditing, not a property named ShareWorkbook or similar.

4fill in blank

hard

Fill both blanks to create a shared workbook and enable change tracking.

Excel

ActiveWorkbook.[1] = True
ActiveWorkbook.[2] = 30

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

AMultiUserEditing

BKeepChangeHistory

CEnableSharing

DAllowEditRanges

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing AllowEditRanges with sharing

Using EnableSharing which is not a valid property

Setting KeepChangeHistory before enabling sharing

Setting MultiUserEditing to True enables sharing, and KeepChangeHistory to 30 enables tracking changes for 30 days.

5fill in blank

hard

Fill all three blanks to save a shared workbook with a password and enable change history.

Excel

ActiveWorkbook.SaveAs Filename:="SharedBook.xlsx", Password:="[1]", [2]:=True
ActiveWorkbook.[3] = 30

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

Asecret123

BShareWB

CKeepChangeHistory

DReadOnlyRecommended

Attempts:

3 left

💡 Hint

Common Mistakes

Using ReadOnlyRecommended instead of ShareWB

Omitting the password or using an empty string

Not enabling KeepChangeHistory for history

Use a password like secret123 to protect the file, set ShareWB to True to enable sharing, and KeepChangeHistory to 30 to keep change history for 30 days.