Restrictions on shared Excel document

Copper Contributor

Hi there,

In my school I have set up a shared Excel spreadsheet for fellow teachers to use in order to book students into lunchtime support.

I have a tab set up for each week, and on Monday I move the most current week to the 'start'and move the previous week to the 'end'. I want to keep each tab as a record for staff to consult over the year.

The problem is that staff keep adding new tabs, dragging round the order and generally messing things up.

Is there any way to give shared users editing rights to type into cells, but to prevent them from adding new tabs or reordering tabs.

Any number of instructions/requests are falling on deaf ears....teachers are the worst...

Thanks.

jcairns656

1 Reply

@jcairns656 

The problem is that staff keep adding new tabs, dragging round the order and generally messing things up.

Is there any way to give shared users editing rights to type into cells, but to prevent them from adding new tabs or reordering tabs.

 

Review menu - protect workbook structure. Add a password.

clipboard_image_0.png