Disable "New" in Excel Toolbar in VB .NET

Posted on 2004-10-22
Last Modified: 2010-04-23
Programmatically, using VB .NET, I can disable File > New in Excel.  However I am having trouble disabling "New" in the toolbar. How can I do that? Also how can I disable Ctrl + N? I tried Application.OnKey("^N", "") but it doesn't work.
Question by:HeitmanProgrammers
    LVL 1

    Author Comment

    I only want to disable for the workbook that I am on. Not for the whole application.
    LVL 18

    Accepted Solution

    >>I can disable File > New in Excel

    can you paste the code for it ?
    LVL 1

    Author Comment

    I can disable it however it disables on the whole application. I only want to disable it for the current workbook. Also, I need to disable "New" from the toolbar (toolbar with all the shortcurts).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Prepare to Pass the CompTIA A+ 900 Series Exam

    CompTIA aims to adapt its A+ Certification to reflect the most current knowledge and skills needed by today's IT professionals--and this year's 2016 exam is harder than ever. This certification is one of the most highly-respected and sought after in IT.

    Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
    Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    933 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now