Disable User From Adding Sheets

  • Hi guys,

    I want to disable the Function "add sheet" in general.
    The only way to add a sheet is per makro.

    Is there a function to disable "add sheet"? I want all the other functions (add rows, add columns...) as they are

    Thanks in advance

  • Re: Disable User From Adding Sheets

    Hi Bilbo,

    If all you want to do is stop the user from adding a sheet (i.e. changing the structure of the workbook) then simply go to Tools, Protection, Protect Workbook and select Structure and select OK, you have the option of entering a password or leaving this blank.

    If there is something more to what you are asking, please clarify.

    Cheers Gizzmo

  • Re: Disable User From Adding Sheets

    Another approach is program a macro that deletes every sheet when adding one:

    Copy this in your ThisWorkbook Module

    Private Sub Workbook_NewSheet(ByVal Sh As Object)
        Application.DisplayAlerts = False
        Application.DisplayAlerts = True
        MsgBox "You cannot insert sheets in this workbook."
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!