• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 2. Managing and Viewing Workbooks > Protecting and Sharing Workbooks

Protecting and Sharing Workbooks

Open the Tools menu, choose Protection, and select Protect and Share Workbook to open the Protect Shared Workbook dialog box.

Click the Sharing with Track Changes check box, which activates the Password (optional) text box.

Type a password in the Password (optional) text box, and press the Enter key (or click OK). Users will be required to enter the password to access this workbook.

Type the same password in the Confirm Password dialog box, and press the Enter key.

INTRODUCTION

When you share files with other users, you might find it useful to protect your workbooks. You can protect your workbooks by restricting access to the workbook and preventing changes being made within each particular workbook. The three protection options are Protect Sheet, Protect Workbook, and Protect and Share Workbook. Don't forget any passwords you assign to your workbooks; otherwise, you are not able to access the workbook.


TIP

Alternative file-sharing options

There are two other file-sharing options in Excel. Protect Sheet allows you to protect the contents, objects, and scenarios in a worksheet (and assign a password). Protect Workbook allows you to protect the structure and windows in a workbook (and assign a password).


Excel notifies you that this action will save the workbook. Click OK when you receive this message.

[Shared] now appears to the right of the filename in the title bar.

Open the Tools menu, choose Protection, and select Unprotect Shared Workbook to open the Unprotect Sharing dialog box.

Type the workbook's password in the Password field and click OK to disable the password protection. [Shared] no longer appears in the Title bar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint