How does one permanently set View->Window Options->Page Break in Excel 2004?

[baltwo]

I've repeatedly set the subject prefs, click OK, save and close an
Excel workbook/sheet, reopen it, and it doesn't show the page breaks.
What the hey? How can I set a workbook to permanently show the page
breaks?

 

[Bill Weylock]

Don¹t know what you mean by subject prefs.

Go to Excel/Preferences/View and check Show Page Breaks. That should do it.


Best,


- Bill

I've repeatedly set the subject prefs, click OK, save and close an
Excel workbook/sheet, reopen it, and it doesn't show the page breaks.
What the hey? How can I set a workbook to permanently show the page
breaks?

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[baltwo]

You missed the point, Bill. I've been doing that ("repeatedly set the
subject prefs" via the appropriate link: Excel->Prefs->View) and it's
the only Window option that won't stay set.

 

[Bill Weylock]

Not knowing what ³subject prefs² are is a problem.

Hope someone else can help.

You missed the point, Bill. I've been doing that ("repeatedly set the
subject prefs" via the appropriate link: Excel->Prefs->View) and it's
the only Window option that won't stay set.

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[J Laroche]

I've repeatedly set the subject prefs, click OK, save and close an
Excel workbook/sheet, reopen it, and it doesn't show the page breaks.
What the hey? How can I set a workbook to permanently show the page
breaks?

Yes, that's quite incredible that worksheets forget the value of this
property when saved. Here's a way to work around the problem, problem that
MS should fix (maybe done in XL04, I don't have it to check).

Put the following VBA code in a new workbook, in the ThisWorkbook page
(Crtl-click on the workbook's title bar and select View Code). Save the
workbook with the name Workbook (without extension) in
Applications/Microsoft Office X/Office/Startup/Excel. Newly created
workbooks will permanently show page breaks. However existing workbooks
won't, unless this code is put in them too. Also, for the second macro
(NewSheet) to work, you must not have a workbook called Sheet saved in the
directory mentioned above.

This proposition is an all-or-nothing case. If there is one sheet in a
workbook for which you don't want line breaks to show, you can remove them
with the preferences, but they will reappear each time you open the
workbook.

JL
Mac OS X 10.3.7, Office v.X 10.1.6



' Put this code in ThisWorkbook
' Forces all page breaks to show on opening
' JL 2005-01-09
Private Sub Workbook_Open()
For Each Sh In ThisWorkbook.Sheets
Sh.DisplayPageBreaks = True
Next
End Sub

Private Sub Workbook_NewSheet(ByVal Sh As Object)
Sh.Move After:=Sheets(Sheets.Count)
Sh.DisplayPageBreaks = True
End Sub

 

[Paul Berkowitz]

He meant "the prefs specified in the subject of this email". It shows what
happens when you try to take too many shortcuts to save yourself some
typing: people don't understand what you're trying to say. If people don't
understand, they can't help.

"baltwo" (? It would also help if you used a display name or a signature in
your emails that was more communicative too: it's hard to have a discussion
with a baltwo) , and others:

Please remember that your readers are human beings. If you're hoping to get
help, it's in your own interests to put yourself in their place and write
your messages in language that other people can understand without going
through contortions. Don't save 5 seconds of typing by using cryptic
expressions or abbreviations: take the trouble to spell it out clearly.
You'll get more answers.

So does anyone know why "baltwo" can't get Excel->Prefs->View->Window
Options->Page Break to save permanently?

From JL's response and VBA solution, it sounds like it must be a bug since
he can reproduce it.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.



From: Bill Weylock <[email protected]>
Newsgroups: microsoft.public.mac.office.excel
Date: Sun, 09 Jan 2005 07:33:37 -0800
Subject: Re: How does one permanently set View->Window Options->Page Break
in Excel 2004?

Not knowing what ³subject prefs² are is a problem.

Hope someone else can help.

You missed the point, Bill. I've been doing that ("repeatedly set the
subject prefs" via the appropriate link: Excel->Prefs->View) and it's
the only Window option that won't stay set.

Panther 10.3.6
Office 2004
Windows XP Pro SP2
Office 2003

 

[J Laroche]

Paul Berkowitz wrote on 2005/01/09 15:26:

<...>

So does anyone know why "baltwo" can't get Excel->Prefs->View->Window
Options->Page Break to save permanently?

From JL's response and VBA solution, it sounds like it must be a bug since he
can reproduce it.

I just checked Excel 2000 on Windows today. The same thing happens. So maybe
this is by design? In the Windows version I didn't see any checkbox to set
the page breaks like in the Mac version. The only way I found was to make a
Print Preview or set the property in the VBA property window.

Maybe baltwo would also be satisfied by going to View/Page Break Preview.
This is a setting that definitely sticks when the workbook is closed.

JL
Mac OS X 10.3.7, Office v.X 10.1.6

 

[JE McGimpsey]

You missed the point, Bill. I've been doing that ("repeatedly set the
subject prefs" via the appropriate link: Excel->Prefs->View) and it's
the only Window option that won't stay set.

Assuming "the subject prefs" means the (singular) preference mentioned
in your subject line (which is rather poor posting technique), this
appears to be a bug. OTOH, this preference is also much less persistent
by design. For instance, going from Normal view to Page Layout view
automatically sets the preference, which makes some sense.

I have a button on my custom toolbar that is attached to this macro
(which I keep in a template in the Startup folder, so that it's always
accessible):

Public Sub TogglePageBreaks()
With ActiveSheet
.DisplayPageBreaks = Not .DisplayPageBreaks
End With
End Sub

One could also assign a keyboard shortcut. Of course, if you always want
to see page breaks (I almost never do), you'll still have to manually
set them when the workbook opens.

If you always want a particular sheet to show page or not show page
breaks, you can put this macro in the ThisWorkbook code module
(CTRL-click the workbook title bar and choose View Code):

Private Sub Workbook_Open()
Sheets("Sheet1").DisplayPageBreaks = True
End Sub

 

[baltwo]

Sorry about having a name that doesn't meet Mr. Berkowitz's criteria,
but I haven't found the link that will allow me to
change/modify/correct my contact information within this Google
account. Anyway, I was trying to change Excel (2004, as shown in the
initial post)->Excel menu item->Preferences->View->Window Options->Page
Breaks, so that when I reopened a saved document with that setting,
page breaks would appear. From what the other posters have written,
it's broken. Thanks for the time spent responding.

I'll just manually do the preferences dance (sorry for the poor
reference, but I grew up with applications only having one preferences
option under its menus).