From the course: Excel 2013 Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Assigning passwords to workbooks

Assigning passwords to workbooks - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Assigning passwords to workbooks

If you have multiple users of this workbook, you might want to think out a couple of schemes regarding who can access the workbook, in other words who can open it and also who can make changes to it. When you save a workbook you have options. For example, if we click the File tab in the Ribbon and choose Save As and recognize I am using Windows 8 you might not be but no matter what your using here, if you go to the appropriate location where you're about to save the current file, you're likely to see a dialog box and although perhaps a little different than this, it probably has the general characteristics. The term we're looking for here is going to be Tools, often in the lower right-hand corner and then General Options. You'll see a Password to open, Password to modify. The more you think about these possibilities you might realize that there are actually three possible scenarios, one of them might be the following. You've got an organization of say ten or fifteen people, eight or…

Contents