View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lou Sanderson Lou Sanderson is offline
external usenet poster
 
Posts: 26
Default stop running code

I've got some real quick code that I used to refresh all my linked data so I
dont get any messages every time a chart changes. I would like to be able to
add some sort of a break in the code so it will stop if i tell it to. Can
anyone help me with this?

Here is my code:

sub macro1()
application.displayalerts = false

sheets("sheet1").select
range("a1").select
activeworkbook.refreshall
application.displayalerts = true
msgbox ("refresh complete")

end sub

Thanks,
Lou Sanderson