开发者

Disable Insert Sheet/ Delete Sheet Menu using VBA in Excel 2007

Is it possible to Disable the Sheet Delete and Sheet Insert Menu by using VBA in Excel 2007 using the RibbonID Number?

This works well with Excel 2003开发者_运维知识库. But i have no idea of the code in Excel 2007.


See point 3 for a example file to do it with VBA on this page http://www.rondebruin.nl/ribbon.htm

[EDIT] Same subject discussed here : How to disable (or remove) the "protect sheet" and "protect workbook" button in excel 2007 menu?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜