From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Use workbook protection to prevent use of sheet commands

Use workbook protection to prevent use of sheet commands - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use workbook protection to prevent use of sheet commands

“

- [Instructor] Excel has a number of commands 2 related to the worksheets within a workbook. 3 If you right click on a worksheet tab, 4 you see quite a few choices here. 5 Now, we're not going to go through every one of these, 6 but there certainly could be times when you say, 7 "I don't want all those commands to be visible." 8 Maybe it's a situation where this workbook 9 is used by multiple people, 10 not at the same time, but at different times. 11 Possibly this next worksheet over 12 is something you're experimenting with. 13 That data might be confidential, semi confidential. 14 Maybe you don't want that to be visible. 15 A lot of people are familiar with the idea 16 that you can right click a sheet tab and hide the sheet. 17 Okay, well couldn't someone else who's looking at this 18 right click and un-hide? 19 Sure could. 20 Well maybe you want to inhibit that command 21 as well as some others. 22 On the…

Contents