Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
IN XL95 I added a custom category to the worksteet menu bar called
"ListActions." Under "ListActions" are listed peoples names. In XL75, I could press Alt-L and the "ListActions" list would be appear. I could then press the first letter of the name, and the associated Macro would run. In XL97 the list appears, but I must use the mouse to designate the specific name. In an earlier post, I learned that I must put an ampersand "&" in front of the letter to be used for the key board short cut. The problem is how edit existing menu in XL97 so I need not redo all of the numerous menus from scratch. For unknown reasons, I've not been able to load XL95 on my machine, so I can not go back and make the modification before the 95 to 97 conversion. In XL97, when I go to toolbars/customize/commands, it lists most all of the items on the worksheet menu bar such as file, edit, view .... help. It does not list "ListActions," the category shown to the right of HELP. Since "ListActions" is not listed, I can't edit it to add the appersands. I have not been able to find it listed elsewhere as well. I'm sorry if some parts of this question may overlap prior inquires, but with the transition from Win98SE to WinXP, some of my e-mail messages have gotten lost. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xl97 Custom Built in Button greyed out | Charts and Charting in Excel | |||
Xfer of XL95 custom menus into XL97 | Excel Worksheet Functions | |||
Editing XL95 custom menus with XL97 | Excel Worksheet Functions | |||
Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros | Excel Programming | |||
Removing menu bar customization from old XL95 files | Excel Programming |