B
Bill
This a followup on a previous post why Do you want to save
changes pops up when nothing has changed.
It turns out a combo box seems to have something attached
that changes the file. I created the box as a test using
the control toolbox toolbar. I right clicked the combo
box and selected properties and in the listfillrange typed
in list (a named range).
Now when I open the file and close it, the pop up happens.
This happens on a new workbook as well.
Another thing happens using a checkbox, where in another
new workbook I inserted a checkbox. I right clicked on it
and selected view code, looked, didn't change anything and
closed file. Now when I open the file Excel asks if I
want to enable macros
Can any one tell me what is happening here?
Thanks very much
changes pops up when nothing has changed.
It turns out a combo box seems to have something attached
that changes the file. I created the box as a test using
the control toolbox toolbar. I right clicked the combo
box and selected properties and in the listfillrange typed
in list (a named range).
Now when I open the file and close it, the pop up happens.
This happens on a new workbook as well.
Another thing happens using a checkbox, where in another
new workbook I inserted a checkbox. I right clicked on it
and selected view code, looked, didn't change anything and
closed file. Now when I open the file Excel asks if I
want to enable macros
Can any one tell me what is happening here?
Thanks very much