Hello: I am a self-taught private developer and have produced an extensive spreadsheet that relies on a variety of VB macros that are accessed through a detailed macro-generated Custom Menu Bar that appears on the Excel Command Bar after the Help option. I have developed the model in Excel 2000 with Windows 98, but of course not all potential users will have the same combination of Excel and OS on their PC. I am now in Beta-Testing and some others who have Excel 2000 who have tried to use the software with Windows 2000 (vs 98 where developed) get a "Sub-script out-of-range" error when they try to open the spreadsheet. The error (per the MS Knowledge Base Q211924) is occurring when the VB macro initialization procedure I've created tries to set up a Custom Menu Bar. Apparently, Excel needs to access a file on the user's hard drive with the extension .xlb in order to add items to the Worksheet Command Bar, and in some instances that file can be Read-Only. The simple solution would appear to be to change the file property to allow write access, but the problem is, a few of them with Windows 2000 can not even find a file with the extension .XLB on their laptop hard drive (hidden or otherwise) and in network applications, the user may also not have access rights to this file. Does anyone have any advice on the following: 1. Where and what is the file used by Excel 2000 with Window's 2000 that controls access to modify the Excel Command Menu? I also need this information for other OS's. 2. Is there a reliable universal way to create a Custom Command Menu (generated and removed via VB macros) that will work on all Excel 2000+ systems independent of the Operating System? The answer may be Active X, but I'm hoping for an entirely Excel Environment Option if that's possible. Thanks. Steve Provol Independent Developer CEIInc@san.rr.com

Hi Steve I have Office 97, and the file in question for that version is Excel8.xlb found in C:\Windows folder. Here is some info about Excel 2000 / 2002 and where the xlb file is located. http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q280659 Good luck...Krystyna