| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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%. |
|
#2
|
|||
|
|||
|
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%. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the default settings for pivot tables in Excel? . | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| [Excel] How do I change the default import external data settings. | Excel Discussion (Misc queries) | |||
| How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
| How do I change the default settings in charts? | Charts and Charting in Excel | |||
Linear Mode
