How do I change default settings to page break preview
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%. |
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%. |
All times are GMT +1. The time now is 10:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com