class module

[rinku261]

Hi There

Is there any way I want each time when I close any of the workbooks it pops up a msg and if I select yes it allows me to close me the file. If I choose no, then it keeps the file open. It should be something like the built-int message that asks if I want to save an unsaved workbook, but I want this to work even if the workbook is in a saved state. <?XML:NAMESPACE PREFIX = O /><O:P></O:P>
I think it has to go in the Personal Macro Workbook since I want it to work with every workbook opened on my machine. I’ve heard it requires something called a class module, but how do I do that in a personal macro workbook?

<O:P></O:P>
I know its tricky, but I believe in you people. Please help.<O:P></O:P>
cheers
Rinku <O:P></O:P>

 

[VoG]

Create a blank Excel File, add the following to the ThisWorkbook module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If MsgBox("Do you want to save", vbYesNo + vbQuestion) = vbYes Then Me.Save
End Sub

Save the file as Book.xlt in the XLSTART folder.

 

[rinku261]

Hi There

Thanks for the code ...............I saved the code into a wrkbook and saved the workbook with the name u suggested into xlstart folder ....................But the problem is the massage appears only when i am closing the Entire Excel...Not when i am closing workbook.....


I mean the c0de is working only when i am pressing Alt F4(Close excel) not when i am pressing Alt F C (Close the excel file)


Thanks

Regards
Rinku