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 0361-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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
