Disable Save under Excel 2000
 

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.

Disable Save under Excel 2000
 

Weird. Adding some command buttons do not cause a problem like this for me
under Excel 2000. No idea what it might be though.

--
Jim
"Ben" wrote in message
...
| 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.

Disable Save under Excel 2000
 

Do you have any comboboxes/listboxes (from the control toolbox toolbar) in the
workbook?

If you do, do they have linkedcells and listfillranges on the same sheet?

Maybe you could try (against a copy) dropping both the linkedcells and
listfillranges to see if you're still prompted.


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

Disable Save under Excel 2000
 

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.

Disable Save under Excel 2000
 

Sorry, I don't have another guess.



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

Disable Save under Excel 2000
 

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

Disable Save under Excel 2000
 

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

Disable Save under Excel 2000
 

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