Closing Workbook without Saving in BeforeClose event.

[prajul89]

Hi All,

I have a workbook which i opened ReadOnly.
Now When User tries to close workbook, a macro runs in beforeClose Event.

Here I want thisworkbook to be close without saving anything.

I tried Adding

Thisworkbook.close false

But it starts the never ending Loop and excel Hang...

I can't use application.enableevents either because i can't turn it to true after thisworkbook.close line.

Is there any way to do this?

 

[prajul89]

Okay I got the solution.
I use me.saved = true to bluff excel