How to avoid Excel save pop-up

[Rayner]

During workbook close, how to avoid excel save, don't save pop-up.
We already fool the excel by telling it, we saved.. But still the pop-up is throwing.
It is not coming for all excels we have. I have a .xlsm file, only for which it is coming. Sorry that I can't able to share my program.
Following is my workbook close event in vba.

Private Sub App_WorkbookBeforeClose(ByVal wb As Excel.Workbook, Cancel As Boolean)
My code
wb.saved = True
End Sub

I also tried Activeworkbook.Saved = True, Thisworkbook.Saved = True, nothing is working fine..
Please leave your inputs to solve this.

[:) Sixthsense :)]

Please go through the modules to find My code. Since My Code is a Macro Name which is called in your workbook close event.

So please share the My Code Macro codes too for fixing the issue.

[Rayner]

I attached the complete close event.

[Rayner]

That code is working fine for many years. Only with the .xlsm file which we have now, the pop-up is coming. I wish to share the excel, but I can't due to some restriction. I know making false to .EnableEvents and .DisplayAlerts will prevent this. But I cannot give that as a workaround,

[:) Sixthsense :)]

I believe it is happening when you close the excel application completely without keeping any of the other excel window.

Am I right?

[Rayner]

Yes it is right

[:) Sixthsense :)]

Do you have any class modules?

[Rayner]

Ya we do have lots of class modules

[:) Sixthsense :)]

Please wait for couple of hours I called for all members help for fixing your issue…

[Rayner]

Any updates?

[:) Sixthsense :)]

I believe it's happening becuase of the Personalised Event Created using the Class Module.

But the class modules are beyond my knowledge and I already called for all members help here

http://www.excelforum.com/the-water-...3-onwards.html

In post # 374 and I hope someone will join in and help you in fixing the issue