Prevent User from Inserting New Sheet Object

[denwo2010]

Hi,

Is it possible disable "New Sheet Object" from users so that they cannot add their own filters and charts etc...?

Thanks

[#2]

Yes, its possible just go to Settings>Document Properties>Security Tab>Uncheck Add sheet..

[denwo2010]

Hi, I have just done that and I can still right click on the tab, select "New Sheet Object" and select "List Box" for example and then have my own filter selection?

[#4]

Go to sheet properties:- uncheck add sheet objects and check Apply to all sheets option.

[denwo2010 · Accepted solution]

I have done it now by doing the following:

Document Properties

Server

Untick "Allow Server Objects"

[#6]

But, if you Untick "Allow Server Objects" in server, it will not allow users to share the Bookmarks. So, to allow users to share Bookmarks and restrict them to create New sheet Objects, the best way is suggested by swatipanwal above.

[#7]

But, if you Untick "Allow Server Objects" in server, it will not allow users to share the Bookmarks. So, to allow users to share Bookmarks and restrict them to create New sheet Objects, the best way is suggested by swatipanwal above as Go to sheet properties:- Uncheck Add Sheet Objects and check Apply to all sheets option.