My excel file have 2 sheets with named "A" and "B"
我的excel文件有两张表，命名为A和B
Both sheets showed the data from 6 queries (6 connection name) with view of sql server
两张表都显示了从6个查询(6个连接名)到sql server视图的数据。
Ordinary when I want to update the data in excel file, I press "refresh all"
当我想要更新excel文件中的数据时，我按下"refresh all"
but when I protect sheet "refresh all" can't process
但当我保护表“刷新所有”时不能处理
How Do I refresh all sheets including those with protection.
我如何刷新所有的床单，包括那些有保护的。
2 个解决方案
#1
1
check out this solution
看看这个解决方案
How to protect cells in Excel but allow these to be modified by VBA script
如何在Excel中保护单元格，但允许VBA脚本修改这些单元格
https://*.com/a/126032/6868389
https://*.com/a/126032/6868389
#2
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
但是对我来说，“刷新所有”需要15分钟
and "protect sheet" process is begin to process before "refresh all" process has done
“保护表”过程在“刷新所有”过程完成之前开始处理
#1
1
check out this solution
看看这个解决方案
How to protect cells in Excel but allow these to be modified by VBA script
如何在Excel中保护单元格，但允许VBA脚本修改这些单元格
https://*.com/a/126032/6868389
https://*.com/a/126032/6868389
#2
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
但是对我来说，“刷新所有”需要15分钟
and "protect sheet" process is begin to process before "refresh all" process has done
“保护表”过程在“刷新所有”过程完成之前开始处理