Jimbo

Assign this macro to the button.

Sub BreakView()
ActiveWindow.View = xlPageBreakPreview
ActiveWindow.Zoom = 100
End Sub


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 03:03:01 -0800, "Jimbo693"
wrote:

In excel (Office 2000) I have customised my tool bar to include a "Page break
preview" button - the default setting for this button is 60%. - how do I
change this to 100%.