References to Other Workbooks Don't Stick
Yes, I'm saving it. And if I do nothing else than to add the reference and
try to exit, it prompts me to save it, so that Excel "knows" that the file
has been changed.
George
"Ryan H" wrote in message
...
Are you saving the workbook with the reference added to it? I hope so,
just
had to ask. Add the reference like you said in the VBE then click the
Save
button. Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan
"George B" wrote:
Excel 2007 on Vista: When I add a reference (Visual Basic;
Tools/References)
to a workbook with VBA code, the macros become available and executable.
When I try to exit from this workbook with the just-added reference, it
tells me the workbook has been modified and prompts me to save it. But
when
I open it back up, the reference is gone. The same process worked fine
on
my old system with Excel 2000.
What am I doing wrong?
.
|