Clever Geek Handbook

Disable deletion sheet

I would also like to prevent the user from deleting some sheets. How do I do this in Excel 2010? Application.CommandBars("Ply")

does not work any more.

+3


source to share


1 answer


you can do this by protecting the structure of the workbook (I think this setting is in the Protection section of the Overview tab)



I believe this is the only way to prevent the user from deleting the sheet, although it can be known using VBA Workbook events that the sheet has been deleted - See this answer in Excel MVP Colo at MerExcel.com

+3


source






More articles:


All Articles