Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randon file saves
It is possible to avoid the warning prompt if:
1. the file is being closed in VBA 2. Application.DisplayAlerts is also set to FALSE -- Gary's Student "brando13" wrote: This is an odd problem that I have not seen anybody discuss before, so I don't know where else to look.... I have a user in my company that is experiencing problems when he closes out of an excel file. Basically, he will NOT be prompted to save the file he was working on whenever he exits that file... It just exits him out of the file... When he re-opens the file, no changes made have been stored. And oddly enough, it doesn't happen all of the time... We've tried looking at various settings to see if we're missing something, but... Anybody got any ideas as to what's happening and how it can be fixed?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Randon file saves
Okay.... So how do I check these???
Also, if that were the case, why would it not prompt to save SOME of the time??? "Gary''s Student" wrote: It is possible to avoid the warning prompt if: 1. the file is being closed in VBA 2. Application.DisplayAlerts is also set to FALSE -- Gary's Student "brando13" wrote: This is an odd problem that I have not seen anybody discuss before, so I don't know where else to look.... I have a user in my company that is experiencing problems when he closes out of an excel file. Basically, he will NOT be prompted to save the file he was working on whenever he exits that file... It just exits him out of the file... When he re-opens the file, no changes made have been stored. And oddly enough, it doesn't happen all of the time... We've tried looking at various settings to see if we're missing something, but... Anybody got any ideas as to what's happening and how it can be fixed?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create buttom that saves current file in a given filename (Excel) | Excel Worksheet Functions | |||
Excel file automatically opens | Excel Discussion (Misc queries) | |||
Filling Text from Another File | Excel Worksheet Functions | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
File saves ok, SaveAs VERY slow | Excel Discussion (Misc queries) |