Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted prompts when clsoing a workbook
There are several threads on how to avoid the "Would you like to save
the changes you have made ..." pop-up box, using the ThisWorkbook.Close (False) or ThisWorkbook.Close (True) features. I have used this successfully, and it runs nicely on my computer. However, when transfering the code (it's in a .xla addin) to a colleague, the SaveChanges information is ignored, and the "Would you like to save the changes you have made ..." pop-up box appears. Both computers run Excel 2003. I have also tried the optional forms ThisWorkbook.Close (SaveChanges =False) and ThisWorkbook.Close SaveChanges :=False,; it makes no difference. Any suggestions will be greatly appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted prompts when clsoing a workbook
Sub terminatt()
Application.DisplayAlerts = False ActiveWorkbook.Saved = True ActiveWorkbook.Close End Sub -- Gary''s Student - gsnu200825 "Eivind" wrote: There are several threads on how to avoid the "Would you like to save the changes you have made ..." pop-up box, using the ThisWorkbook.Close (False) or ThisWorkbook.Close (True) features. I have used this successfully, and it runs nicely on my computer. However, when transfering the code (it's in a .xla addin) to a colleague, the SaveChanges information is ignored, and the "Would you like to save the changes you have made ..." pop-up box appears. Both computers run Excel 2003. I have also tried the optional forms ThisWorkbook.Close (SaveChanges =False) and ThisWorkbook.Close SaveChanges :=False,; it makes no difference. Any suggestions will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
close/open workbook without prompts | Excel Programming | |||
Avoid Prompts on Workbook open? | Excel Programming | |||
Unwanted Jump to Linked Workbook | Excel Worksheet Functions | |||
Error on opening and clsoing Excel | Excel Programming | |||
Error message while clsoing excel and word applications. | Excel Discussion (Misc queries) |