prevent deleting of sheets in Excel

Q132. In Excel, how can I prevent other users from adding or deleting Sheets in file?

For example, I have a complex WorkBook with hidden Sheets, formulas involving multiple Sheets. I want to prevent users from adding or removing Sheets or hiding or unhiding Sheets.

To do it in Excel, here is the answer:

a) Click on "Info" under "File". Click on "Protect WorkBook Structure" under "Protect WorkBook".

excel prevent deleting of sheets

b) In the "Protect Structure and Windows" dialog box, check "Structure" option and enter Password. Re-enter Password. Click OK.

The WorkBook structure is protected and cannot be changed without the Password.

Note: Select the Windows option if you want to prevent users from moving, resizing, or closing the WorkBook window, or hide/unhide windows.

excel excel prevent deleting of sheets


You can find similar Excel Questions and Answer hereunder

1) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

2) I am planning to protect my sheet using a password. However, for select cells I would like users to be able to edit the cells. In Excel, how can I achieve that?

3) I have to enter non alphanumeric characters in a cell using VBA - how can I get their codes for use in VBA?

4) Is there a way I can round the sales figure to the nearest 500?

5) How do I update my DropDown list whenever the sheet is activated?

6) How can I prevent users from entering duplicate values in a range?

7) Line break in vba message box in Excel

8) How can I find the number of working days between 2 dates using VBA?

9) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

10) Vba code to password protect workbook in Excel

11) How can I extract file name from a full path?

12) Userform initialize vs userform show in Excel

13) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

14) I have a table where inputs have to come from various users. In Excel, how can I highlight a row automatically that does not have input so that I can follow up with the concerned?

15) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?