vba code to remove the tools menu

**jpruffle** · 09-02-2009, 08:42 AM

Hi,

Is there code available that will hide the Tools Menu within excel?

Thank you in advance,

JP

**sweep** · 09-02-2009, 08:53 AM

Hi,

Try this - it's from memory, so no promises!

Please Login or Register  to view this content.

**jpruffle** · 09-02-2009, 09:13 AM

Thank you for the reply. I am still new to VBA how do I call this line of code?

**dominicb** · 09-02-2009, 09:31 AM

Good afternoon jpruffle

You need to make it part of a routine, such as :

Please Login or Register  to view this content.

You can run it by going to Tools > Macro > Macros, select test and click Run.
You will have to make an alternate way of calling it after you remove your Tools menu though

.
To reinstate your Tools menu change the word False to True.

You could replace the main line with this line to ghost the Tools menu out instead of hiding it outright :

Please Login or Register  to view this content.

HTH

DominicB

**royUK** · 09-03-2009, 03:36 AM

Being new to VBA here's a warning. You must take extreme care when removing toolbars and generally changing user settings that you restore them exactly after your code has fiished.