求助关于WorksheetView和SheetViews对象

laoyebin

2007里新增的对象，帮助里写的语焉不详，不知道怎么用

看到MR EXCEL的网站上有一段用法
An example:

You want to analyse the calculations in a workbook with several worksheets. You want to have 2 windows of this workbook, such that in the second window all the worksheets display their formulas.

This code displays a second window for the active workbook and changes the DisplayFormulas property for all the worksheets when displayed in the second window. The code is too detailed but I wanted to show all the object chain.


Code:
Sub FormulasDisplay()
Dim wbk As Workbook
Dim win As Window
Dim shtViews As SheetViews
Dim wsView As WorksheetView

Set wbk = ActiveWorkbook
Set win = wbk.NewWindow
Set shtViews = win.SheetViews

For Each wsView In shtViews
    wsView.DisplayFormulas = True
Next wsView

End Sub

但还是没明白这两个对象到底有什么作用，希望知道的帮答疑解惑一下

laoyebin

顶起来，用2007的来给我解释一下哦

laoyebin

还是没人看到这个帖子，顶起来继续