How to disable right click “delete” option on worksheets tab












0














Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook will disable this but what if I want to disable it while protecting or not protecting all together?



Application.CommandBars("Ply").FindControl(ID:=847).Enabled = False 


will disable it but if the workbook/worksheet had a password protected, when un protecting it, the command will be disregard and the delete worksheet can still be done.










share|improve this question






















  • stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
    – Raystafarian
    Apr 27 '16 at 11:50










  • those don't work.
    – user582635
    Apr 28 '16 at 13:12
















0














Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook will disable this but what if I want to disable it while protecting or not protecting all together?



Application.CommandBars("Ply").FindControl(ID:=847).Enabled = False 


will disable it but if the workbook/worksheet had a password protected, when un protecting it, the command will be disregard and the delete worksheet can still be done.










share|improve this question






















  • stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
    – Raystafarian
    Apr 27 '16 at 11:50










  • those don't work.
    – user582635
    Apr 28 '16 at 13:12














0












0








0


1





Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook will disable this but what if I want to disable it while protecting or not protecting all together?



Application.CommandBars("Ply").FindControl(ID:=847).Enabled = False 


will disable it but if the workbook/worksheet had a password protected, when un protecting it, the command will be disregard and the delete worksheet can still be done.










share|improve this question













Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook will disable this but what if I want to disable it while protecting or not protecting all together?



Application.CommandBars("Ply").FindControl(ID:=847).Enabled = False 


will disable it but if the workbook/worksheet had a password protected, when un protecting it, the command will be disregard and the delete worksheet can still be done.







microsoft-excel vba






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Apr 26 '16 at 21:31









user582635

926




926












  • stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
    – Raystafarian
    Apr 27 '16 at 11:50










  • those don't work.
    – user582635
    Apr 28 '16 at 13:12


















  • stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
    – Raystafarian
    Apr 27 '16 at 11:50










  • those don't work.
    – user582635
    Apr 28 '16 at 13:12
















stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
– Raystafarian
Apr 27 '16 at 11:50




stackoverflow.com/questions/13702186/… and stackoverflow.com/questions/23645870/…
– Raystafarian
Apr 27 '16 at 11:50












those don't work.
– user582635
Apr 28 '16 at 13:12




those don't work.
– user582635
Apr 28 '16 at 13:12










1 Answer
1






active

oldest

votes


















0














Option Explicit
' To Activate right click on tab - run the following
Private Sub Worksheet_Activate()
Application.CommandBars("Ply").Enabled = False
End Sub

' To Deactivate right click on tab - run the following code
Private Sub Worksheet_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub





share|improve this answer





















    Your Answer








    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "3"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1070169%2fhow-to-disable-right-click-delete-option-on-worksheets-tab%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    Option Explicit
    ' To Activate right click on tab - run the following
    Private Sub Worksheet_Activate()
    Application.CommandBars("Ply").Enabled = False
    End Sub

    ' To Deactivate right click on tab - run the following code
    Private Sub Worksheet_Deactivate()
    Application.CommandBars("Ply").Enabled = True
    End Sub





    share|improve this answer


























      0














      Option Explicit
      ' To Activate right click on tab - run the following
      Private Sub Worksheet_Activate()
      Application.CommandBars("Ply").Enabled = False
      End Sub

      ' To Deactivate right click on tab - run the following code
      Private Sub Worksheet_Deactivate()
      Application.CommandBars("Ply").Enabled = True
      End Sub





      share|improve this answer
























        0












        0








        0






        Option Explicit
        ' To Activate right click on tab - run the following
        Private Sub Worksheet_Activate()
        Application.CommandBars("Ply").Enabled = False
        End Sub

        ' To Deactivate right click on tab - run the following code
        Private Sub Worksheet_Deactivate()
        Application.CommandBars("Ply").Enabled = True
        End Sub





        share|improve this answer












        Option Explicit
        ' To Activate right click on tab - run the following
        Private Sub Worksheet_Activate()
        Application.CommandBars("Ply").Enabled = False
        End Sub

        ' To Deactivate right click on tab - run the following code
        Private Sub Worksheet_Deactivate()
        Application.CommandBars("Ply").Enabled = True
        End Sub






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Apr 29 '16 at 5:45









        0m3r

        867616




        867616






























            draft saved

            draft discarded




















































            Thanks for contributing an answer to Super User!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1070169%2fhow-to-disable-right-click-delete-option-on-worksheets-tab%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Aardman Animations

            Are they similar matrix

            “minimization” problem in Euclidean space related to orthonormal basis