How to Prevent Worksheet from Deleting

[taratata]

Hi,

I am trying to prevent users from deleting a worksheet by accident. However, I do not want to completely lock the sheet because users are allowed to make changes and ammend the data.

Does anyone know how to do this?

[Leah]

Select the cells that are allowed to be changed, go to Format, Format Cell, and choose the Protection Tab. There will be a check mark in the Locked box. Unclick that and that cell will be available for change once you protect the worksheet.

[starguy]

Hi,

I am trying to prevent users from deleting a worksheet by accident. However, I do not want to completely lock the sheet because users are allowed to make changes and ammend the data.

Does anyone know how to do this?

go to menu Tools > Protection > Protect Workbook
and check the option Structure (and give a password if you want)
it will restrict a user to delete any sheet accidently.

Regards.