ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   stop running code (https://www.excelbanter.com/excel-programming/346868-stop-running-code.html)

Lou Sanderson

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


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com