Disable Save under Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
| 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.
 
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.
 
Hi Dave,

I have comboboxes/listboxes on few user forms
not on the worksheets of the workbook.
 
Are any of those controls tied back to a worksheet?

If you remove them (in that test workbook), does the problem go away?
 
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.
 
I don't know why it works that way. But you may want to put all the
"assignments" in code.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addin not allowing thisworkbook.save in before save event 3
Excel Providing user message when RED X clicked & properly closing application. 2
Can't delete sheets 8
Need help with Workbook_BeforeClose event 8
Problem with "ThisWorkbook.Saved" property. 6
All Workbook Saved except This Workbook 3
trying to get out 4
window locking after opening another workbook... 2

Back
Top