ActiveX control causes "Reset project" notice on file open

[GeoBrooks]

I've added two combobox controls to an XL2007 macro-enabled workbook because
I needed to capture their values b4 they were changed. Now when the workbook
is closed, then reopened, I get two "This action will reset your project..."
messages on opening.

I know I can prevent the messages by changing the state of "Notify Before
State Loss" in VB. I need to be able to prevent these messages before
distributing the workbook. How can this be done?

Thanks.

Geo

 

[GeoBrooks]

Update:

If saved as an XL2003 workbook and opened in 2003, there are no reset
messages. If the 2003 workbook is opened in 2007 there are no reset
messages. If the 2003 workbook is saved as .xlsm and opened in 2007 the
reset messages reappear.

So, why?

G

 

[Mahonri]

I have the exact same problem. Is there anyone out there that has a
solution?!?

Mahonri

 

[Mahonri]

I've noticed you've posted this all over the web. If you get a solution,
Could you send it to me if it is not posted here?
davidt(a_t)aristatek(d_ot)com
Thanks

 

[GeoBrooks]

The only solution I found was starting over in a fresh workbook. I had a
recipe for reproducing the error, but it was only good on my system. I guess
it's nice to know my situation was not unique.

fwiw, here's the recipe:
1. Cells: A1 = 1, A2 = 2, B1 = A, B2 = B
2. Insert ActiveX combobox somewhere on sheet
3. Combobox properties:
a. Column count: 2
b. Column widths: 0;43
c. LinkedCell: A4
d. ListFillRange: A1:B2
4. Make selection from combobox to get entry in Linked cell
5. Save, close then reopen. No error.
6. Change combobox name.
7. Save, close, reopen. Error: “This action will reset…â€

Good luck. Be nice to know if you find a solution.

George