View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Alastair79 Alastair79 is offline
external usenet poster
 
Posts: 12
Default VB Help (Excel Warnings)

Perfect, thanks Jon.

"JON JON" wrote:

TRY

Application.DisplayAlerts = False
your code here

Application.DisplayAlerts = True

"Alastair79" wrote in message
...
I have a .CSV file which I have created a macro to go through and sort
data.
But when I save it I have about six million warning messages asking if I'm
sure I want to save my work.

Can I set the warnings to false and close the sheet from within my Macro?

Thanks............. Alastair.