Thread: Querytable refreshing on a protected spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Querytable refreshing on a protected spreadsheet
CDC

You have to refresh it in code. I haven't found a way to refresh it without
first unprotecting the sheet.

Sheet1.Unprotect
Sheet1.QueryTables(1).Refresh False
Sheet1.Protect

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

CDConsultant wrote:
How do I allow a querytable to refresh while the spreadsheet is
protected?


Reply With QuoteReply With Quote