I don't know why it works that way. But you may want to put all the
"assignments" in code.

Ben wrote:

Hi Dave,

Yes, they are tied to a worksheets and
when I removed them the problem go away.

Maybe I have to change them, but I still don't understand why
I'm having this problem.

"Dave Peterson" wrote:

Are any of those controls tied back to a worksheet?

If you remove them (in that test workbook), does the problem go away?

Ben wrote:

Hi Dave,

I have comboboxes/listboxes on few user forms
not on the worksheets of the workbook.

"Ben" wrote:

Hi,
I have code like this: ThisWorkbook.Saved = True in the last line of the
Workbook_BeforeClose event. When I open my workbook and click on the X to
close it I'm not prompted if I would like to save the workbook under Excel
2003 but under Excel 2000 I got that message to save.
On my sheets I have few Command buttons picked from the Control Toolbox.

Any ideas why I'm having the save message only with Excel 2000.

Thank you.

--

Dave Peterson


--

Dave Peterson