Disable Insert Worksheet command

May 4, 2005 at 05:13:32
Specs: Win XP Pro Sp1, P-III 866 Mhz / 128 MB


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?



See More: Disable Insert Worksheet command

Report •

May 4, 2005 at 23:05:15

I got the solution.

I visited another form. For the soultion refer following link.

Thanks all,

Report •

May 5, 2005 at 00:26:35

Check out another link

Here i got further help on this topic.


Report •

Related Solutions

Ask Question