disable right click on sheet delete/insert sheet in excel

[rana19]

R/sir
please send the Vba Macro code to than i am right click on sheet disable delete/insert option in command menu thanking you sir

[y_not]

http://p2p.wrox.com/excel-vba/60867-...worksheet.html

[rana19]

r/sir
i am not under stand with your answer sir please send the vba micro code for disable right click on sheet delete/insert sheet in excel thanking you sir

[rana19]

please reply sir

[davesexcel]

r/sir
i am not under stand with your answer sir please send the vba micro code for disable right click on sheet delete/insert sheet in excel thanking you sir

y_not sent you a link to the answer,
Did you not click on the link and see that the answer was there?

[rana19]

R/Sir
this vba code was not workings on disable sheet Delete/Insert,than i am right click on sheet name & disable delete & insert this vba code was not working this vba macro code only disable right click menu delete & insert function please resolve this issue or send the correct vba macro code for this sir thanking you sir

[davesexcel]

You can completely turn off the right click on sheet tabs, if you want to turn off individual controls in the "ply" control bar that is a bit difficult as it might require xml code.
Anyway to turn off the right click menu when you right click on the sheet tab.

Please Login or Register  to view this content.

[davesexcel]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.