Frustrating excel issue can you help?

jgallcash

I often work between both word and excel. A little annoyance I have is that I often use the red X in the top right hand corner to exit a word document. Now if I have not saved my work then I am prompted to do so….Great. However, if I have more than one excel workbook open and use the Red X to close then often both workbooks will be closed without prompting to save workbooks. This has caught me out a couple of times now. I know the obvious answer is to exit work books via the small Black X in the top right hand corner and to save before closing but there must be another solution?

The_Grandmaster

jgallcash wrote: »

I often work between both word and excel. A little annoyance I have is that I often use the red X in the top right hand corner to exit a word document. Now if I have not saved my work then I am prompted to do so….Great. However, if I have more than one excel workbook open and use the Red X to close then often both workbooks will be closed without prompting to save workbooks. This has caught me out a couple of times now. I know the obvious answer is to exit work books via the small Black X in the top right hand corner and to save before closing but there must be another solution?

May not be a good solution but maybe try and always use control and s to save every so often. A good habit especially if programme suddenly crashes.

Vomityspice

Why not just write a short VBA macro to save your workbook on close??

That way, excel will automatically save when you hit the red button

Fairwinds

What version of excel are you using?

littlepanther

OK, there are two things here. Switch on Autosave by going into Tools menu and selecting Options.. At least you wont lose too much.

You are closing the application by clicking in the top right hand corner, if you only want to close the workbook that is open click on the X that is below the X in the top right hand corner.

Finally, Excel will prompt you to save any unsaved workbooks that are open when you close Excel. I have seen many people disagree with me but then it turns out they have clicked the wrong button when promoted to save.

Fairwinds

Standard Excel procedure is that it will ask to save unsaved changes before closing. However I have read about an issue affecting 2003. Hence why asking which version you are using

Vomityspice

Try this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

jgallcash

Vomityspice wrote: »

Try this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

!!!!!!!!!:eek: That is literally German to me.

The version at work is 2003.

googler

Vomityspice wrote: »

Try this:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayAlerts = False
ActiveWorkbook.Save
Application.DisplayAlerts = True
End Sub

Try this WHERE?

Type it into cells? If not, where.....?

PhilCo_2

googler wrote: »

Try this WHERE?

Type it into cells? If not, where.....?

If you want to use that you'll need to go to the VBA editor (press ALT&F11), double click on This Workbook in the left panel and paste the code on the right panel. Only problem with it is you'll need to make sure macros are turned on for it to work.

PhilCo_2

jgallcash wrote: »

I often work between both word and excel. A little annoyance I have is that I often use the red X in the top right hand corner to exit a word document. Now if I have not saved my work then I am prompted to do so….Great. However, if I have more than one excel workbook open and use the Red X to close then often both workbooks will be closed without prompting to save workbooks. This has caught me out a couple of times now. I know the obvious answer is to exit work books via the small Black X in the top right hand corner and to save before closing but there must be another solution?

If more than one file is being closed you should get a message box per file asking if you want to save. If no changes have been made to a file since you opened it you won't get a save option as there's no need.