Thanks for replying.
I'm using Excel as a front end for an OLAP database and the line with the reconciliation on is hidden from users. I only need to know about if it doesn't balance. An event procedure would be the sort of thing that would be very helpful.
As I'm working through my VBA...
Sorry to bother everyone here, but I'm starting to learn VBA and having some difficulty running the following routine in Excel:
Private Sub Worksheet_Calculate()
If Range("a25").Value <>0 Then
MsgBox ("Imbalance")
End If
End Sub
I'm placing the macro in the Worksheet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.