Sheet-level security

At the sheet level, we can also determine what actions our users are allowed to make. The sheet-level privileges can be opened by selecting Settings | Sheet Properties in the menu and selecting the Security tab. This tab is shown in the following screenshot:

Sheet-level security

The following table lists and describes the various user privileges that can be set at the sheet level:

User privilege

Description

Add Sheet Objects

Allows users to add new sheet objects.

Remove Sheet Objects

Allows users to remove any of the sheet objects, not just the ones that they created.

Move/Size Sheet Objects

Allows users to move and size sheet objects. On sheets where we do not want the users to move or size any of the objects, this option is a lot more convenient than deselecting Allow Move/Size on each individual sheet object.

Copy/Clone Sheet Objects

Allows users to create a copy of existing sheet objects.

Access Sheet Object Properties

Allows users to access the Sheet Properties dialog.

Remove Sheet

Allows users to delete the sheet.

Access Sheet Properties (Users)

Allows users to access the Properties pages of objects on the sheet.

By selecting the Apply to All Sheets checkbox, we can apply the currently selected privileges to all sheets in the document.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset