Menu Editor
 

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

Menu Editor
 

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

On Mon, 11 Oct 2004 12:32:14 +0800, "Billy Leung"
wrote:

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

Menu Editor
 

Do you mean the Toolbars?

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


Right Click anywhere on the toolbars and choose "Customise"

or

View ToolBars Customise

Celtic_Avenger
:) :) :) :) :

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=26807

Menu Editor
 

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


"Celtic_Avenger" wrote in
message ...

Do you mean the Toolbars?

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


Right Click anywhere on the toolbars and choose "Customise"

or

View ToolBars Customise

Celtic_Avenger
:) :) :) :) :)


--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile:
http://www.excelforum.com/member.php...o&userid=14101
View this thread: http://www.excelforum.com/showthread...hreadid=268072

Menu Editor
 

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

"Billy Leung" wrote in message
...
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


"Celtic_Avenger" wrote in
message ...

Do you mean the Toolbars?

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


Right Click anywhere on the toolbars and choose "Customise"

or

View ToolBars Customise

Celtic_Avenger
:) :) :) :) :)


--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile:
http://www.excelforum.com/member.php...o&userid=14101
View this thread:
http://www.excelforum.com/showthread...hreadid=268072

Menu Editor
 

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

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...fo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=26807

Menu Editor
 

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

"Billy Leung" wrote in message
...
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

Menu Editor
 

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


On Mon, 11 Oct 2004 22:07:27 +0100, "bigwheel" wrote:

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

"Billy Leung" wrote in message
...
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