[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 185
  • Last Modified:

Disable "New" in Excel Toolbar in VB .NET

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.
0
HeitmanProgrammers
Asked:
HeitmanProgrammers
  • 2
1 Solution
 
HeitmanProgrammersAuthor Commented:
I only want to disable for the workbook that I am on. Not for the whole application.
0
 
armoghanCommented:
>>I can disable File > New in Excel

can you paste the code for it ?
0
 
HeitmanProgrammersAuthor Commented:
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).
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now