References to Other Workbooks Don't Stick
Thanks. That worked. I only had code in one of the workbooks.
But now I have a different problem. I've added my macros to the Quick
Access Toolbar, but these are not sticking either. They work fine when I
first add them to the toolbar, but they disappear after closing and
re-opening the workbook. Any suggestions?
Thanks,
George
"Ryan H" wrote in message
...
I was able to recreat the error. The issue happed when I didn't have any
modules in both of the workbooks. If I had a module with some code in
both
workbooks then save both workbooks the references held. Try that.
I assume Excel automatically drops the reference if there isn't any code
in
the workbook to reference. Kinda makes sense, but it would be nice to
warn
users before dropping the reference that you assign automatically because
the
abscents of code.
Hope this helps! If so, let me know, click "YES" below.
--
Cheers,
Ryan
"George B" wrote:
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?
.
.
|