Page breaks reappearing when switchingbetween Normal and Page Layout View

C

claude_sapp

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I unchecked Show page breaks in Preferences...View, and in Normal view they went away. But when I switch between Normal and Page Layout views, the page breaks reappear. Any other setting to look at that would prevent this?
 
J

JE McGimpsey

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I unchecked Show page breaks in Preferences...View, and in Normal view they
went away. But when I switch between Normal and Page Layout views, the page
breaks reappear. Any other setting to look at that would prevent this?

Don't think so. I've added this script to toggle page breaks to my
Script Menu (by placing it in the

~:Microsoft User Data:Excel Script Menu Items

folder, where ~ is your home directory):

tell application "Microsoft Excel"
tell active sheet
set display page breaks to not (display page breaks)
end tell
end tell
 
C

claude_sapp

That worked, thank you. That is the first time I have ever used a script, but I can see how scripts can be very useful. I will have to learn more about them.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page Breaks 1
Page Layout View Hides Rows at the Bottom of Sheet 6
Page Layout view 17
How to show page breaks that were put in manually 1
PAGE BREAK 5
manual page breaks 4
Page numbers 3
Remove page breaks 1

Top