Menu Editor

[Billy Leung]

Hi,

In the old version Excel (Excel 5.0 -- yes, my company still using Windows
3.1 which is an antique), there was a tool "Menu Editor". This can change
the menu only for the specific excel file with specific macro. In other
words, each excel file can have its own menu. I can't find this tool in the
new version Excel. Would somebody tell me where it is ?

Thanks.


Billy

 

[Myrna Larson]

It's been gone for many versions now. AIR, it was removed in Excel 97.

 

[Celtic_Avenger]

Do you mean the Toolbars?

If so............


Right Click anywhere on the toolbars and choose "Customise"

or

View > ToolBars > Customise

Celtic_Avenger
:

 

[Billy Leung]

Celtic Avenger

No, I am referring to the pull down menu. In the old version, I even can
remove "File" menu !

By the way, I already cross post as per other people suggested in the
newsgroup, not multi-post. Am I doing the right thing ?

Billy

 

[Bob Phillips]

Since 97 there have been what MS call Commandbars. These refer to the menus
and the toolbars. Programmatically, it is relatively simple to manipulate
the menus via the Application.Commandbars.

If you give an example of what you want to do, we can show you some code.

--

HTH

RP

Celtic Avenger

No, I am referring to the pull down menu. In the old version, I even can
remove "File" menu !

By the way, I already cross post as per other people suggested in the
newsgroup, not multi-post. Am I doing the right thing ?

Billy

 

[Bob Phillips]

Hi Billy,

My filters stop attachments.

It would help if you just told me what menus you add, sub-menus etc., what
macros they invoke. Oh, and which menus do you hide?

 

[Celtic_Avenger]

Anther method to think of might be to remove all toolbars using

Application.DisplayFormulaBar = False
Application.CommandBars("Standard").Visible = False
Application.CommandBars("Formatting").Visible = False

and others,

Then use the full screen option, and use then create a user form as
navigation and functionality menu.

Celtic_Avenger

 

[bigwheel]

Sadly, it is no longer part of Excel, but there is an alternative. Go to
http://www.j-walk.com/ss/excel/tips/tip53.htm

 

[Gord Dibben]

Billy

In addition to the other advice and suggestions you received........

If you still have workbooks with menus created using the Menu Editor, you may
have problems with ghost menu items when you open these in a newer version.

To get rid of the custom menus, download Jim Rech's REMOVEMENUS.ZIP file from
Stephen Bullen's site. See instructions and d/l file from:

http://www.bmsltd.ie/MVP/Default.htm

Gord Dibben Excel MVP

 

[Billy Leung]

Hi all,

Thanks a million for your info. I will try your advices one by one (It takes
time.) For other alternative, please refer to microsoft.public.excel and
microsoft.public.excel.programming in same
subject.

Billy

*********************************************************************

Billy

In addition to the other advice and suggestions you received........

If you still have workbooks with menus created using the Menu Editor, you may
have problems with ghost menu items when you open these in a newer version.

To get rid of the custom menus, download Jim Rech's REMOVEMENUS.ZIP file from
Stephen Bullen's site. See instructions and d/l file from:

http://www.bmsltd.ie/MVP/Default.htm

Gord Dibben Excel MVP