Disable delete sheet

Question

I would like also to prevent user to delete some of the sheets. How to do that in excel 2010? Application.CommandBars("Ply") doesn't work any more.

Answer 1

you can do this by protecting the structure of the workbook (I think that option is under Protection in the Review tab)

I believe this is the only way to actually prevent the user deleting a sheet, although it can be possible to find out using VBA Workbook events that a sheet has been deleted - See this answer by Excel MVP Colo on MerExcel.com