L
lou sanderson
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
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