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?

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?


.

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?


.

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?


.



.

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?


.



.

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.
--
Cheers,
Ryan


"George B" wrote:

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?


.



.



.

Ryan,

Will do. Thanks for your help.

George

"Ryan H" wrote in message
...
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.
--
Cheers,
Ryan


"George B" wrote:

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?


.



.



.