closing workbook without save-question

[runkle]

Hi

Is there another way to turn off the auto save-question when closing a wkbk than

Activeworkbook.close false

since i have to run it in a wkbk_BeforeClose i can't use the close-command again or the makro will run twice.

thanks for your help

runkle

 

[Derek Brown]

Are you looking for the following?

Activeworkbook.Saved = True

 

[runkle]

haha nice, i almost gave up.. never thought it would be easier to just lie to excel =D
thanks!!