1

My excel file have 2 sheets with named "A" and "B"

Both sheets showed the data from 6 queries (6 connection name) with view of sql server

Ordinary when I want to update the data in excel file, I press "refresh all"

but when I protect sheet "refresh all" can't process

How Do I refresh all sheets including those with protection.

Community
  • 1
  • 1
Tr Rt
  • 11
  • 2

2 Answers2

1

check out this solution

How to protect cells in Excel but allow these to be modified by VBA script

https://stackoverflow.com/a/126032/6868389

Community
  • 1
  • 1
lllpratll
  • 368
  • 1
  • 3
  • 8
0

my code is work if time for "refresh all" is a short time

but for my case "refresh all" take time about 15 minutes

and "protect sheet" process is begin to process before "refresh all" process has done

enter image description here

Cù Đức Hiếu
  • 5,569
  • 4
  • 27
  • 35
Tr Rt
  • 11
  • 2