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
"Mahonri" wrote:
> 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" wrote:
>
> > 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
> >
> > "GeoBrooks" wrote:
> >
> > > 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
|
Similar Threads
