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


    Code
    Private Sub Workbook_NewSheet(ByVal Sh As Object)
    Application.DisplayAlerts = False
    Sh.Delete
    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!

Register Yourself Login