Closing an excel file display dialogue box to save changes

[jb]

I have an excel file where some sheets contains formulas. Formula uses ROW, ADDRESS, CLEAN, MATCH and INDIRECT function. Now whenever I am closing this EXCEL without making any changes then also it displays dialogue box with options save changes , don't save and cancel.

Is it possible that it should not display this box?

 

[Santy28]

Hi JB,


Its good to save the workings before u close. But still if this itches as the file is large and u dont want to see the save dialog box. Insert below macro for the workbook:


Sub closewbk()

ThisWorkbook.Close savechanges:=False

End Sub


assign a shortcut for the macro and use it instead of closing the Workbook.

 

[jb]

Ya I know that it is good to save changes. But this dialogue box with options save changes , don't save and cancel is displayed even if I have not done any changes. This dialogue box should be displayed only when I have done some changes.


As I have mentioned my excel file contains formulas which uses ROW, ADDRESS, CLEAN, MATCH and INDIRECT function.

Help me.

 

[jb]

Do not want to show save changes dialogue box if no changes have been done.

 

[mahaveer]

i hope this link will useful to you....bcoz it seems as like you put a query here...

http://www.xtremevbtalk.com/showthread.php?t=90357


Regards

CA Mahaveer Somani