I tried the macro in your article. When I open a new workbook and try to use the header macro it says that jeffs book of macros is already open and you can not have two files open with the same name. Did I leave someting out?
I am glad you enjoyed the article. Be sure that you do not have two instances of Excel open. If you open excel, it will open jeffs book of macros automatically. Then, if you open the excel program again (instead of opening a workbook within the currently running excel program), the second instance of excel will attempt to open jeffs book of macros again - thus giving you the error message.
I did not have two instances of excel open when I encountered this error. I opened excel which opened jeffs book of macros automatically (it is hidden so you can't see it unless you unhide) I then clicked on open new workbook and tried to run the macro when I encounter this error message. Thanks for you help.
Based on what you are saying, it sounds to me like you have two copies of "jeffs book of macros.xls" on your computer. One of which is in your xlstart directory, and opens automatically when you start excel. The second is probably in your "my documents" directory or something, and that is the one that you used to set up your custom menus. Thus, when you attempt to run the macro from the custom menu, excel attempts to open the file - creating an error.
To see if this is the case, open a new workbook and try to run the macro by Tools -> Macro -> Macros, and select the header macro from the list and run it. If it runs properly, then it indicates that the custom menus are pointing to a second jeffs book of macros workbook. If so, simply re-assign the macro for the custom menu items to point to the jeffs book that is in your xlstart directory. I know this seems involved, but once it is set up, you will save time.
That did the trick. The Custom Menu was pointing to the directory I cut the file from, using explore, to put it in the xlstart directory. Thanks for your help!!!
Terry, I am glad you
I did not have two instances
I did not have two instances of excel open when I encountered this error. I opened excel which opened jeffs book of macros automatically (it is hidden so you can't see it unless you unhide) I then clicked on open new workbook and tried to run the macro when I encounter this error message. Thanks for you help.
Terry, Based on what you
That did the trick. The
That did the trick. The Custom Menu was pointing to the directory I cut the file from, using explore, to put it in the xlstart directory. Thanks for your help!!!