Page breaks

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi Everyone
Is it possible to have the "Page Breaks" active all the time.
If its by VBA, I would like it too be flexible for one workbook and all
workbook if possible.
Thanking you in advance.
Regards
John
There is no failure except in no longer trying.
Elbert Hubbard
 
Hi Again
Just rephrasing my question.
Is it possible to show the page break on a worksheet without having to go
everytime to > Tools>Options > Page Breaks
 
Thanks Bob
I guess its not possible by Registry or something ??, but you're right I
could add a line to a macro like below.
Sub Page break
ActiveSheet.DisplayAutomaticPageBreaks = True
End Sub
Best regards
John
 

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

Change cell colour to red 6
Excel Macro to un-mute Audio/speakers. 15
Page Break Save 1
Excel Protection 2
Printing 36069 pages 1
Printing Excel workbook 6
Setting Page Breaks 1
break links not working 39

Back
Top