Stop Excel asking if I want to save!

[sevi]

I want to stop Excel 97 asking if I want to save a document every time I’ve mad a change and then try to close it.

Can anyone help?

 

[bryanbayfield]

there are a couple of way I know of that you could do it - they both use VBA.

Simplest solution is to open up VBA editor, click on "ThisWorkbook", select the "BeforeClose" event and insert this code:

       ThisWorkbook.Save

 

[sevi]

Thanks for the reply.

Could you give me a bit more info on how to do this? I’m a bit of a newby.

Also, I need to remove the tool bars etc. Could you let me know how to do this?

Thanks

 

[xlbo]

If you are looking into this kind of functionality, I'd respectfully suggest you need to be a bit more than a "newby". You really need to understand the consequences of removing toolbars, how to replace them etc etc. Maybe an explanation of what you are trying to achieve would be helpful so we can point out some potential pitfalls etc Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde