Solved: Control the execution of macros

[rajagopal]

I've workbook event codes in an excel file say abc.xls
Consider that abc.xls is opened by the user but not modified. In this case, the macros should not get executed.
How this can be done?

Regards

[geekgirlau]

Which workbook event are you using? If you are using the Before Close event, you can do something like this:

[VBA]
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If ActiveWorkbook.Saved = False Then
' rest of code
End If
End Sub

[/VBA]

[rajagopal]

Yes. I use Before close event. Your code meet my requirement when the user do not save the file.
If the user save the empty file accidentally, then the macros will be executed.
Is there any other way to instruct the macros to get executed only when the sheet is updated??

Regards

[Bob Phillips]

In ThisWorkbook

[vba]

Private mChangeFlag As Boolean

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If mChangeFlag Then
'run your code
End If
End Sub

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
mChangeFlag = True
End Sub
[/vba]

[rajagopal]

Thanks a lot. It works fine.
May i know the explanation of mchangeflag code?

Regards

[Bob Phillips]

It just tells the close routine whether anything was changed.