View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Tina MC Tina MC is offline
external usenet poster
 
Posts: 1
Default Right-click the sheet tab and select "View Code"Paste this macro

No no! It's much simpler than anything I've read here... Save and close down Excel completely. When you reopen it, it will be back to normal. :)

On Wednesday, December 30, 2009 4:14 PM Garyntx wrote:


Someone at my office had a file that when opened. (Excel 2007) would show
every cell with page breaks showing hidden lines around every cell. Couldn't
figure out out to remove the breaks. It would not allow you to remove them. If
you hit print preview it would say something like 1 to 4000 pages. Is there a
simple fix for this?



On Wednesday, December 30, 2009 4:19 PM Pokey wrote:


You should be able to go to view and hit normal right above page break preview.

"Garyntx" wrote:



On Wednesday, December 30, 2009 4:37 PM Garyntx wrote:


tried that. the lines go away but it still wants to print each cell
separately and will not let you remove the page breaks.

"Pokey" wrote:



On Wednesday, December 30, 2009 4:38 PM Barbara Wiseman wrote:


One of my collegues had the same thing happen, although it was on excel
2003. He changed printer and it was fine. It seemed to be a temporary
problem with the connection to one printer.
Barbara



On Wednesday, December 30, 2009 5:22 PM KChotmail com wrote:


Right-click the sheet tab and select "View Code"

Paste this macro in:
Private Sub fixbreaks()
ActiveSheet.ResetAllPageBreaks
End Sub

Hit the green play button.
Ctrl+A to select the entire macro, then hit the Delete key.
Alt+Q to get out of the macro editing window.

That should take care of it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Garyntx" wrote:



On Wednesday, March 16, 2011 10:11 PM Marilyn Sliwa wrote:


THIS WORKED, BUT WHEN I CLICKED ON 'VIEW CODE' & PUT BOX ON "WORKSHEET" INSTEAD OF "GENERAL", I GOT THE FOLLOWING:



"Private Sub Worksheet_SelectionChange(ByVal Target As Range)



End Sub"



I HAD TO DELETE THE ABOVE "" SO THE ONLY THING ON PAGE WAS THE MACRO ITSELF.



WOULD NOT WORK OTHERWISE.

did this:



1. PRESS "VIEW CODE"

2. PUT WORD IN BOX TO "WORKSHEET"

3. DELETE "PRIVATE SUB WORKSHEET_ ETC. (ABOVE "")

4. COPY MACRO & PASTE IT, SO THAT MACRO IS THE ONLY THING ON THE PAGE.

then continue as indicated:

5. Hit the green play button.

Ctrl+A to select the entire macro, then hit the Delete key.

Alt+Q to get out of the macro editing window.