hierarchical protection workbook

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

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

Hierarchical protection of a workbook

resolvedResolved · 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

RE: hierarchical protection of a workbook

Sorry It's Excel 2010.


 

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips


Server loaded in 0.09 secs.