How much do you want to show?

Which toolbars to be shown for MAXROWS?

Which for NORM?

Would you also want to turn off other display optiions like formula bar, status
bar, scrollbars?

More info will assist in getting some code but here is a sample.

Sub maxrow()
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
With Application
.CommandBars("Standard").Visible = False
.CommandBars("Formatting").Visible = False
End With
End Sub


Gord Dibben MS Excel MVP

On Sat, 8 Dec 2007 16:26:00 -0800, JLGWhiz
wrote:

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