Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

hierarchical protection workbook

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hierarchical protection of a workbook

Hierarchical protection of a workbook

ResolvedVersion 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

RE: hierarchical protection of a workbook

Sorry It's Excel 2010.

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.