View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default custom view to display specific toolbars

You might be trying to pick apples from the orange grove. I believe the
toolbars are independent and would not be affected by the view status. You
would have to control them separately.

"pwrichcreek" wrote:

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