I have developed an application in Excel using VB Editor. I expect that user should not insert any worksheet into this application.
I used following line in my VBA code
Application.CommandBars("Insert").Controls(4).Enabled = False
However, it dose not work.
The same command works for other toolbars like "File", "Format", "Tools" etc.
Can someone help me to resolve this problem?