A couple years ago i made a giant spreadsheet and had 2 custom toolbars to run macros from to manipulate the sheet.
This year i re-did the sheet, meaning all my old data was replaced (it's a giant schedule basically).
the Macros in the custom toolbars stayed exactly the same and performed the same function and are directed to the exact same
cells, rows, columns, etc..
But now when i hit the buttons on the custom toolbars to run my macros, i get the
following message... all the time...
A document with the name "NHLsheet.xls" is already open. You cannot open two documents
with the same name, even if the documents are in different folders.
To open the second document, either close the document that's currently open, or rename one of the documents.
Trouble is, i have only 1 document open!
There's something in the macros that thinks i'm trying to open a new document but i'm clueless as to where or why.. they are
very simple macros
that do not require the opening of any new workbooks..
All they do is point to another sheet within my open
workbook, "NHLsheet", copy a particular row from that sheet, and paste it to a specific spot onto another sheet
within my workbook, "NHLsheet".
Here is a sample:
' ANAhome Macro
' Macro recorded 04-02-2008 by ...
I think it has to do with the fact that i created these macro toolbars 2 years ago for use in the workbook i had used 2 years
though nothin has really changed..
I can't figure out why it insists that there is another copy
of "NHLsheet" open somewhere??
Can anyone help?