Disable Insert Worksheet command

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

Hi!,

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?

Thanks,

Niko


See More: Disable Insert Worksheet command

Report •


#1
May 4, 2005 at 23:05:15

I got the solution.

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

http://www.vbaexpress.com/forum/showthread.php?p=25072#post25072

Thanks all,
Niko


Report •

#2
May 5, 2005 at 00:26:35

Check out another link

http://www.ozgrid.com/forum/showthread.php?t=33419

Here i got further help on this topic.

Niko


Report •

Related Solutions


Ask Question