References to Other Workbooks Don't Stick

[George B]

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?

 

[Ryan H]

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.

 

[George B]

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]

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.

 

[George B]

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]

I was not able to duplicate that issue. I opened a workbook, wrote a test
macro, then added the macro to the Quick Access Toolbar, saved the workbook,
closed Excel, reopened the workbook and it stayed on the toolbar.

Since this is a new issue from your original post, I'd post this as a
separate question and maybe someone else has had the problem. I can't
duplicate it.

Hope this helps! If so, let me know, click "YES" below.

 

[George B]

Ryan,

Will do. Thanks for your help.

George

I was not able to duplicate that issue. I opened a workbook, wrote a test
macro, then added the macro to the Quick Access Toolbar, saved the workbook,
closed Excel, reopened the workbook and it stayed on the toolbar.

Since this is a new issue from your original post, I'd post this as a
separate question and maybe someone else has had the problem. I can't
duplicate it.

Hope this helps! If so, let me know, click "YES" below.