Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.tw.excel,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.tw.excel,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
#8
Posted to microsoft.public.tw.excel,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Editor Menu Bar and Toolbar disappears | Excel Discussion (Misc queries) | |||
VBA editor | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) | |||
Menu editor | Excel Programming | |||
Menu Editor /Windows Menu | Excel Programming |