My Dear Cuan,
Thanks a lot for prompt help. The code suggested by you has solved my
problem.
Regards,
Randhir Singh
On Tue, Oct 13, 2009 at 3:12 PM, Cuan wrote:
>
> Giday Randhir
>
> I've found the following to be useful for suppressing those annoying
> alerts
>
> Application.DisplayAlerts
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
what are you using to close the file?
normally, if you're using the .Close method
(as in: Workbooks(workbookname).Close)
you can use:
Workbooks(workbookname).Close SaveChanges:= False
Paul
From: "Randhir Singh, AGM CPM-1, LHO, CHD"
To: excel-macros@googlegr
