Prev: Automatically Saving created FILE
Next: timer for sheet
From: Michelle on 6 Jun 2010 06:05
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

From: Mike H on 6 Jun 2010 07:59
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
>
 | 
Pages: 1
Prev: Automatically Saving created FILE
Next: timer for sheet