Disable delete sheet in Excel 2010
In Excel 2003, I had a macro that disabled the delete sheet command. I've recently upgraded to Excel 2010 and the old macro doesn't work any more.
Application.CommandBars("Worksheet Menu Bar").Controls("Edit") _
.Controls("Delete Sheet").Enabled = False
Any suggestions on how to do this in Excel 2010?
I'd also like to disable the rename command.
In fact, I'd like to disable the right-click menu on the sheet tab too.
Disabling the Right Click menu is simple enough. Just put this code the the ThisWorkbook code module
Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) Cancel = True End Sub
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks Mike,
I copied your code and pasted it into the This Workbook module but it didn't make any difference. I still get the right click menu.
What am I missing? Do I need to change the arguments in the brackets in the subroutine?
Regards,
Steve
I misread the requirements. The code I posted disables right clicking on a cell, not on a sheet tab.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks