خرید بک لینک

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.

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 8 ارديبهشت 1395 ساعت: 5:19

صفحه بندی