Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Disable Insert Worksheet command

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Disable Insert Worksheet command

Reply to Message Icon

Name: Niko9999
Date: May 4, 2005 at 05:13:32 Pacific
OS: Win XP Pro Sp1
CPU/Ram: P-III 866 Mhz / 128 MB
Comment:

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



Sponsored Link
Ads by Google

Response Number 1
Name: Niko9999
Date: May 4, 2005 at 23:05:15 Pacific
Reply:

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


0

Response Number 2
Name: Niko9999
Date: May 5, 2005 at 00:26:35 Pacific
Reply:

Check out another link

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

Here i got further help on this topic.

Niko


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Disable Insert Worksheet command
Macro - Inserting rows into Excel www.computing.net/answers/office/macro-inserting-rows-into-excel/5107.html

Excel: date from form to worksheet www.computing.net/answers/office/excel-date-from-form-to-worksheet/7817.html

Disable worksheet insertion. www.computing.net/answers/office/disable-worksheet-insertion/9214.html