ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Extracting Custom Views from a File (https://www.excelbanter.com/excel-programming/386171-extracting-custom-views-file.html)

ExcelMonkey

Extracting Custom Views from a File
 
How do you extract the names of the custom views from an excel file?

Thanks

EM

NickHK

Extracting Custom Views from a File
 
Private Sub CommandButton3_Click()
Dim CusView As CustomView

For Each CusView In ThisWorkbook.CustomViews
Debug.Print CusView.Name
Next

End Sub

NickHK

"ExcelMonkey" wrote in message
...
How do you extract the names of the custom views from an excel file?

Thanks

EM





All times are GMT +1. The time now is 10:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com