Hi Vivek, I told you to write the code under ThisWorkbok but you wrote the code under Sheet1.
Check the attached file.
On Tue, Jun 9, 2009 at 3:10 PM, vivek jain <vivek.j...@gmail.com> wrote:
> Dear Ajay,
>
>
>
> I tried the solution provided by you. But I couldn’t do it. I am attatching
> the file in which I copied the code provided by you. Please have a look at
> it and let me know where I went wrong.
>
>
>
> Thanks & Regards..
>
>
>
> CA Vivek Jain
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Ajay Varshney
> *Sent:* Monday, June 08, 2009 7:31 PM
> *To:* excel-macros@googlegroups.com
>
> *Subject:* $$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR
>
>
>
> Hi Vivek,
>
>
>
> Check the attached paint file. This will give you alot of help in getting
> the required results.
>
>
>
>
>
> Use this VBA Code :
>
> Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
> Boolean)
> If Range("B10").Value <> Range("D10").Value Then
> Answer = MsgBox("Total of Assets and Liabilities does not match. Press Ok
> to save or Cancel to edit", vbOKCancel, "Balance Sheet Check Status")
> If Answer = vbOK Then
> Exit Sub
> Else
> Cancel = True
> End If
>
> End If
>
> End Sub
>
>
>
> Change the highlighted range to cell reference where you have mentioned
> total of Assets and Liabilities.
>
>
>
>
>
> Regards,
>
> Ajay Varshney
>
>
>
>
>
> On Mon, Jun 8, 2009 at 4:54 PM, vivek jain <vivek.j...@gmail.com> wrote:
>
>
> Dear Ashish,
>
> Thanks for the reply. But I have no knowledge about writing macros. So it
> would be very kind of you if you could elaborate on the solution.
>
> Thanks & Regards...
>
> Vivek Jain, FCA, DISA (ICAI)
> Vivek Shantilal Jain & Co.
> Chartered Accountants
> 3010 Ram Kumar Arcade,
> Chatribari Road, A T Road,
> Guwahati-781001
> �v0361-2603895,9435019908
>
> -----Original Message-----
> From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> On Behalf Of Ashish Jain
> Sent: Monday, June 08, 2009 2:50 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR
>
>
> Hi Vivek,
>
> Ofcourse this is possible, Use Workbook_BeforeSave event with if
> condition and warning msg.
>
> ---------------------------------------
> Regards
> Ashish Jain
> http://www.excelitems.com
> http://www.openexcel.com
> *Developer of Open XL*
> ---------------------------------------
>
> On Jun 8, 9:30 am, "vivek jain" <vivek.j...@gmail.com> wrote:
> > Dear All groupmembers,
> >
> > I prepare financial statements in excel. To check whether the balance
> sheet
> > tallied I check assets - liabilities in a particular cell which should be
> > zero and add it to watch window.
> >
> > Is it possible that every time I open/save the file it would give me
> warning
> > message that my balance sheet does not tally in case of any difference in
> > assets and liabilities.
> >
> > Thanks & Regards...
> >
> > cid:image001....@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)
> >
> > Vivek Shantilal Jain & Co.
> >
> > Chartered Accountants
> >
> > 3010 Ram Kumar Arcade,
> >
> > Chatribari Road, A T Road,
> >
> > Guwahati-781001
> >
> > (0361-2603895,9435019908
> >
> > image001.gif
> > 2KViewDownload
> >
> > image002.jpg
> > 1KViewDownload
>
> <br
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
test.xlsm
Description: Binary data
