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.
LVL 1
HeitmanProgrammersAsked:
Who is Participating?
 
armoghanCommented:
>>I can disable File > New in Excel

can you paste the code for it ?
0
 
HeitmanProgrammersAuthor Commented:
I only want to disable for the workbook that I am on. Not for the whole application.
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.