I use John Walkenbach's Menu Creation code in Excel 2003:
In some programs this code works and in some programs is doesn't. Where it doesn't I get the following message from executing the "Set MenuObject..." Expression: "Run-time Error 9, Subscript out of range." The only subscript is the "1". Note that cBar which is set to CommandBars(1) works.Please Login or Register to view this content.
If I've run a program that works first and then run a program which by itself creates this error, no error occurs.
How to fix this?
Thanks, Mac
Bookmarks