LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xl97 Custom Built in Button greyed out gloowee Charts and Charting in Excel 0 April 5th 05 08:40 PM
Xfer of XL95 custom menus into XL97 windsurferLA Excel Worksheet Functions 2 February 1st 05 11:33 PM
Editing XL95 custom menus with XL97 windsurferLA Excel Worksheet Functions 11 February 1st 05 06:26 PM
Convert XL2K wkbk w/ macros to XL97? Ed[_9_] Excel Programming 1 February 13th 04 08:46 PM
strange worksheet.codenames in XL97 Arne[_2_] Excel Programming 0 July 28th 03 03:35 PM


All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"