![]() |
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