How to Disable Customize PopUp Window

  • Thread starter Thread starter Kieranz
  • Start date Start date
K

Kieranz

Hi
when I right click the blank area on the File Menu, a window pops up
from which I can then select/deselect things such as Standard, Format
etc and at the bottom Customize and there the Command tab which allows
me drag icons such as SaveAs to the File Menu to enable saveas event if
it was previously greyed out thru procedure. How do I disable or not
show this popup window in vba. Many thks KZ
 
Hi Kieranz,

Try:

Application. CommandBars("ToolBar List").Enabled = False
 
Hi Kieranz,

Deleting the inadvertent space, try:

Application.CommandBars("ToolBar List").Enabled = False
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top