使用工作表变量获取工作表属性 [英] Get worksheet property using worksheet variable

问题描述

很抱歉，如果已经回答了这个问题，但是我没有运气去寻找.

I apologize if this has already been answered, but I had no luck searching on this.

当工作表被变量引用时，访问工作表属性的最佳方法是什么?

What’s the best way to access a worksheet property, when the worksheet is referenced by a variable?

这引发了一个编译错误:

This one raises a compile error:

Sub Tst1(Wk As Worksheet)
    Debug.Print Wk.pbOK
End Sub

此方法有效，但是有更好的方法吗?谢谢.

This one works, but is there a better way? Thanks.

Sub Tst2(Wk As Object)
    Debug.Print Wk.pbOK
End Sub

推荐答案

通过KazJaw的提示，发现在以下情况下，您可以编译该文件没有问题:

With a tip from KazJaw, found out that you can get it compile no issues if:

Sub Tst1(Wk As Worksheet)
    Debug.Print Thisworkbook.Worksheets(Wk.Name).pbOK
End Sub

我能想到的此方法的唯一用途是存储已处理的宏的状态(或将工作表标记为在会话中已处理)，因为重新打开工作簿后不会保存值.

The only usefulness of this method i can think of is to store the state of macro processed (or mark worksheet as processed at a session), as values does not get saved after the workbook is re-opened.

这篇关于使用工作表变量获取工作表属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！