Password Protect Excel Worksheet From Viewing. Hello i am our companies excel workbook creator and i am a self taught newbie to the excel world. Unfortunately i don't believe you can password protect that worksheet however you may be able to achieve what you needing by using the protect workbook option.
Basically, each tab is a sales rep's numbers and management doesn't want the other reps to see that data. Hold down the alt + f11 keys to open the microsoft visual basic for applications window. It should be noted that this method is far from secure and should not be used if the worksheet.
Trust me i tried to find a way to protect this sheet from view.
Users are asked to open the excel file with password. This is a great feature for adding. Users can still save changes by creating a new copy of the workbook. Password protect worksheet from viewing.