ExcelBanter - Querytable refreshing on a protected spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Querytable refreshing on a protected spreadsheet (https://www.excelbanter.com/excel-programming/318563-querytable-refreshing-protected-spreadsheet.html)

CDConsultant

Querytable refreshing on a protected spreadsheet

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

Dick Kusleika[_4_]

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?

All times are GMT +1. The time now is 04:00 AM.