Giday Randhir I've found the following to be useful for suppressing those annoying alerts
Application.DisplayAlerts = False Make sure you remember to turn it back on again at the end of your macro Application.DisplayAlerts = True Cheers Cuan On Oct 12, 3:49 am, "Randhir Singh, AGM CPM-1, LHO, CHD" <sehrawat...@gmail.com> wrote: > hi all > > I have written a macro which copies some data from other work-book but > before copying that data some changes are made in the file from which > data is copied. Thereafter that file (from where data is copied) is > closed without saving changes choosing the 'NO' option on message 'Do > you want to save changes: yes / No'. > > While running macro this file save option appears and 'No' is clicked to > complete the process. Can anybody help me so as to enable me complete > the process without manual intervention i.e. advise some code to > suppress the appearance of file save option. > > Thanks in advance > > Randhir > > sehrawat...@gmail.com --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
