Page breaks appearing spontaneously

C

Charles

I'm having a weird issue with Excel Spreadsheets.
Page breaks seem to appear on spreadsheets for no apparent
reason. The user's, as far as I can tell, didn't put them
their.
The odd part is, each cell has a page break. You go to
print out an Excel file, and 100 pages print out... each
with a cell printed out on it.

The users are running Office 2000 Pro SP3.
Any advice on which direction I should go with this is
appreciated.
 
F

Frank Kabel

Hi
just as a helpt to remove them: Use the following macro

sub remove_all()
ActiveSheet.ResetAllPageBreaks
end sub
 

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

Top