Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Most Recent Custom View
When I add the 'Custom Views' drop-down to a toolbar, it displays the name
of the custom view most recently selected (through the menu) So this information must be stored somewhere... How can I access it in code? I need to know the name of the custom view that has been selected by the user? I've been told it can't be done... but if the toolbar control can read it, the informaion must be somewhere... Any ideas? Thanks M |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Most Recent Custom View
Michelle,
I don't believe Excel strores the name of the last custom view that was used so if a workbook contains multiple custom views then I think whoever told you that you can't do this is correct. I played with trying to trap the name using worksheet change event code but changing the custom view doesn't appear to trigger an event. You can get the names of the custom views Dim cv As CustomView For Each cv In ThisWorkbook.CustomViews MsgBox cv.Name Next and you can set a custom view with code ThisWorkbook.CustomViews("MyView").Show -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Michelle" wrote: When I add the 'Custom Views' drop-down to a toolbar, it displays the name of the custom view most recently selected (through the menu) So this information must be stored somewhere... How can I access it in code? I need to know the name of the custom view that has been selected by the user? I've been told it can't be done... but if the toolbar control can read it, the informaion must be somewhere... Any ideas? Thanks M |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View Custom View with Sheet Protection | New Users to Excel | |||
Help with Custom View | Excel Worksheet Functions | |||
How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
Missing "Custom View" entry from View menu | Excel Discussion (Misc queries) | |||
Custom View Bug? | Excel Discussion (Misc queries) |