close excel application.
 

Hi,

Is there any way I can control the dialog box which prompts to save the
changes of the workbook? Basically I dont want to display the dialog box when
they user clicks on cross.

Thanks

close excel application.
 

Application.DisplayAlerts = False

.....

Application.DisplayAlerts = True

--

HTH

RP

"VJ" wrote in message
...
Hi,

Is there any way I can control the dialog box which prompts to save the
changes of the workbook? Basically I dont want to display the dialog box
when
they user clicks on cross.

Thanks

close excel application.
 

HI VJ

This what I use hope it helps

Application.AlertBeforeOverwriting = False
ThisWorkbook.Close savechanges:=False

This closes the work book with no prompt and does not save changes.

You could easily ammend the code to save with no alerts and close.

Best N10



"VJ" wrote in message
...
Hi,

Is there any way I can control the dialog box which prompts to save the
changes of the workbook? Basically I dont want to display the dialog box
when
they user clicks on cross.

Thanks

close excel application.
 

..alertbeforeoverwriting refers to the warning you get when you drag cells over
non-empty cells.

Not overwriting the another file.

N10 wrote:

HI VJ

This what I use hope it helps

Application.AlertBeforeOverwriting = False
ThisWorkbook.Close savechanges:=False

This closes the work book with no prompt and does not save changes.

You could easily ammend the code to save with no alerts and close.

Best N10

"VJ" wrote in message
...
Hi,

Is there any way I can control the dialog box which prompts to save the
changes of the workbook? Basically I dont want to display the dialog box
when
they user clicks on cross.

Thanks

--

Dave Peterson