98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Hierarchical protection of a workbook
Hierarchical protection of a workbook
Resolved · Urgent Priority · Version 2007
Hierarchical protection of a workbook
Hi Best Stl!
I have created a large workbook of 10 tabs.
I need three permission levels for people entering/editing data;
Administrator: for myself, full control of everything
Manager: able to enter some budget figures/amend cost prices in a couple of rows/columns that need to be protected from editing by the basic user
Basic User: Daily data entry on limited areas only
If possible I do not want the manager to have to protect a worksheet after they have edited it as I do not think they will always remember to do so.
Can you suggest anything?
Thanks
Karen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating charts in Excel 2010Here's how to present your data in a chart format: |