Hello I am our companies excel workbook creator and I am a self taught newbie to the excel world. VBA is not yet a strong point for me however I get along fine using the basic formulas and features made available to me from the Excel 07 software. I have come to a point where I need to insert some code to get the end result I want. Trust me I tried to find a way to protect this sheet from view but nothing was good enough to not just be simply undone.
I have created a quota records sheet that takes nine different employees work and totals it per day, month and then adds it to a line graph for visual competitiveness against the other workers. The last sheet I have is only for the Managers and Assistant Managers eyes. How can I password protect this sheet from view unless a correct password is entered?
1. Password Protect (Sheet 11) "Company Totals"
2. Three Attempts allowed
3. After three attempts have failed it sends you back the the sheet you were previously viewing.
4. Disable the ability for this sheet to be the one viewed first when first opening the file.
5. Only need to enter the password once per session to view this sheet.
If you need more information to understand the solution I want then please ask.
PS: Possible conflicts, Workbook is shared and saved in excel 97-2003 format once editing is finished. This makes the file compatible to all employees using it as we have not yet upgraded everyone to Excel 2007.
Bookmarks