Get Names of ActiveWorkbook.CustomViews

  • Thread starter Thread starter cellist
  • Start date Start date
C

cellist

How can I collect the names of all the defined custom views?

TIA,

Phil
 
this may help you get what you want

Sub test()
Dim i As Long
For i = 1 To ThisWorkbook.CustomViews.Count
MsgBox ThisWorkbook.CustomViews(i).Name
Next
End Sub
 
Thanks Gary. That's exactly what I need.

Gary Keramidas said:
this may help you get what you want

Sub test()
Dim i As Long
For i = 1 To ThisWorkbook.CustomViews.Count
MsgBox ThisWorkbook.CustomViews(i).Name
Next
End Sub
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combobox linked to Custom Views 17
My macro doesn't work with other people's computers? 5
change custom view when leaving a sheet 12
Setting paper size as variable for printing custom views 2
Macro to open view with a password 3
Protect sheet while enabling outlines and custom views 13
Capture Custom View in a Variable 1
Views available to the entire workbook, not just 1 worksheet 2

Back
Top