View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bryan L Bryan L is offline
external usenet poster
 
Posts: 3
Default Disabling external data refresh using vba

Protecting the workbook stops the data from being imported, which is
what I was looking for; however, it also stops the macro from
completeing, because it asked for user intervention to keep going. Is
there a way to suppress this error message, or another way to stop the
data from being imported?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!