Querytable refreshing on a protected spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I allow a querytable to refresh while the spreadsheet is protected?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Refreshing Querytables. 8
Connecting Questions on Querytables 1
QueryTables, some basic questions 5
Question on Deleting Querytables 3
Pivottable refresh problem 1
Invalid Web Query Error 6
how delete old querytables? 2
Help! Query Refreshing 2

Back
Top