VBA Code for disabling Delete function on worksheet tabs

[nanders8]

Is there a way within VBA code to remove or disable the delete function when someone right clicks on a tab within a worksheet?

Thanks
Nick

 

[Scott Huish]

You don't need VBA.

Just use Protect Workbook for Structure

 

[nanders8]

Thanks Scott for that information. Here is the problem when I try that, we have other macros that are linked to buttons which create new sheets. When I protect the workbook structure it does not allow me to use those other macros (buttons) to create sheets. Any suggestions?

 

[Scott Huish]

Unprotect the workbook temporarily in code, and then reprotect it when you are done.

For example,

Sub test()
ThisWorkbook.Unprotect
Worksheets.Add
ThisWorkbook.Protect , True
End Sub