Is there a way to disable the right click "delete" option on the excel worksheets tab at the bottom to prevent users from be able to delete a worksheet. I know that protecting the worksheet/workbook will disable this but what if I want to disable it while protecting or not protecting all together?
Application.CommandBars("Ply").FindControl(ID:=847).Enabled = False
will disable it but if the workbook/worksheet had a password protected, when un protecting it, the command will be disregard and the delete worksheet can still be done.
برچسب:
نویسنده: استخدام کار