From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Protecting workbooks
- We're looking at the workbook 11 - Security&Sharing. Makes no difference what sheet we're working on. But let's imagine we've made some changes to this workbook and we want to save it. And we're also thinking along the lines of some protection. We only want certain people in our organization to be able to open this file from now on. They can make changes to it, that's not the issue. We simply want to restrict who can open this file. It's stored in a folder where people have access to other files and some of those might be protected in a similar way. So, we want to put a password protection on this file. When we go to the command File>Save As, and by the way, the keystroke shortcut for that is the F12 key. Go to This PC and this example here. Now, depending upon which version of Windows you're using, your screen is likely to look something like this. And near the Save and Cancel buttons in the lower-right corner you'll see an option, Tools. Drop arrow, General Options... Now, there…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.