Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to transition an XL95 file to XL97 as part of a move from Win98SE
to WinXP machine. I have lots of experience writing macros for XL95, but I have not yet mastered finding my way around the Visual Basic Editor. When I open the XL95 file in XL97, the Worksheet Menu Bar includes my custom options and the macro links work with some exceptions. I need to explore those macros that do not work. As the sheet has over 100 macros, it can be tough to remember the name for each macro. In Excel95, one could go to the EDIT MENU and see the precise name of the macro that was assigned to the Menu Bar task. I've not been able to do that in XL97. When I open VIEW/TOOLBARS/CUSTOMIZE, a check appears next to "worksheet menu." However the only options are NEW / RESET / ATTACH; there is no EDIT option. I assume that when I find the EDIT option location, I'll be able to see the name associated with each task. If I click on "ATTACH," it shows that there are no "menus" attached to the file that is open. However, I know the my custom Worksheet Menu Bar must be attached because it is displayed. What am I missing? In XL97, I could access the menu tasks using the key board. Alt-L got me to the special LIST function on the menu bar, and then the next key typed would get me to the item within that list, provided it started with the same letter and there were no conflicts. I suspect that option must be disabled by the settings of my copy of XL97. How does one enable that function? |
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 | |||
Convert XL2K wkbk w/ macros to XL97? | Excel Programming | |||
strange worksheet.codenames in XL97 | Excel Programming |