View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pwrichcreek pwrichcreek is offline
external usenet poster
 
Posts: 34
Default custom view to display specific toolbars

I want certain custom views to display only specific toolbars. For example,
I'd like one view, let's call it MAXROWS, to show a maximum number of data
rows, so I'd like that view to display the smallest number of toolbars
possible. When I switch out of MAXROWS to another view, let's call it NORM,
I'd like to see several toolbars.

I can't seem to get this to work using custom views alone. Whatever toolbar
options I customize for MAXROWS are retained when I switch to NORM or any
other view.

It seem as if I should be able to do this using VBA, but I don't have a clue
which EVENTS and METHODS I should be using. (Or, perhaps I can do it without
VBA, but have not yet stumbled onto all the right buttons to push?)

TIA,

Phil