Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
kimmyrt
 
Posts: n/a
Default Printing Problem

Hi, this problem is about to drive me crazy. The page number "001" keeps
showing up in page break view. I know how to go to normal view to not see it,
but the problem is this, the 001 prints out on every 1st page I print. If I
print out 3 pages, only page 1 of 3 has a big 001 in the middle of it. I
checked the header and footer to make sure they had no page numbers. Please
help me get the 001 to stop printing! Please!
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

kimmy

That's the strangest darn thing.

Does this happen with every workbook and sheet or just one?

Perhaps you have some Before_Print code in the ThisWorkbook module that places
the 001 on your sheet.

Right-click on the Excel Icon at top left and "View Code"

See anything in there? If so, report back or delete the code.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 13:17:09 -0800, "kimmyrt"
wrote:

Hi, this problem is about to drive me crazy. The page number "001" keeps
showing up in page break view. I know how to go to normal view to not see it,
but the problem is this, the 001 prints out on every 1st page I print. If I
print out 3 pages, only page 1 of 3 has a big 001 in the middle of it. I
checked the header and footer to make sure they had no page numbers. Please
help me get the 001 to stop printing! Please!


  #3   Report Post  
kimmyrt
 
Posts: n/a
Default

Hey, thanks for responding, I've written in 4 forums and your the first
response! Anyway, I checked the code and it was empty. This happens in
everything, but only on the first page. One thing I left out that I don't
know if it matters, is that I just got a new comp. and I installed the same
version of excel as on the old comp. The 001 only appears on the documents
that I have transfered from the old comp. If I copy and paste the document
into a new excel sheet then it prints fine. Also, the documents are
templates in macros (which I know nothing about). I checked out all the
watermarks and backgrounds and there's none so I am just completely lost.
Thanks again so much for the help!

"Gord Dibben" wrote:

kimmy

That's the strangest darn thing.

Does this happen with every workbook and sheet or just one?

Perhaps you have some Before_Print code in the ThisWorkbook module that places
the 001 on your sheet.

Right-click on the Excel Icon at top left and "View Code"

See anything in there? If so, report back or delete the code.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 13:17:09 -0800, "kimmyrt"
wrote:

Hi, this problem is about to drive me crazy. The page number "001" keeps
showing up in page break view. I know how to go to normal view to not see it,
but the problem is this, the 001 prints out on every 1st page I print. If I
print out 3 pages, only page 1 of 3 has a big 001 in the middle of it. I
checked the header and footer to make sure they had no page numbers. Please
help me get the 001 to stop printing! Please!



  #4   Report Post  
kimmyrt
 
Posts: n/a
Default

In case anybody was still reading this thread, I figured out the problem. It
was the driver. I just installed a new post script driver and now its fine.
Thanks for all the help though! :)

"kimmyrt" wrote:

Hey, thanks for responding, I've written in 4 forums and your the first
response! Anyway, I checked the code and it was empty. This happens in
everything, but only on the first page. One thing I left out that I don't
know if it matters, is that I just got a new comp. and I installed the same
version of excel as on the old comp. The 001 only appears on the documents
that I have transfered from the old comp. If I copy and paste the document
into a new excel sheet then it prints fine. Also, the documents are
templates in macros (which I know nothing about). I checked out all the
watermarks and backgrounds and there's none so I am just completely lost.
Thanks again so much for the help!

"Gord Dibben" wrote:

kimmy

That's the strangest darn thing.

Does this happen with every workbook and sheet or just one?

Perhaps you have some Before_Print code in the ThisWorkbook module that places
the 001 on your sheet.

Right-click on the Excel Icon at top left and "View Code"

See anything in there? If so, report back or delete the code.


Gord Dibben Excel MVP

On Mon, 10 Jan 2005 13:17:09 -0800, "kimmyrt"
wrote:

Hi, this problem is about to drive me crazy. The page number "001" keeps
showing up in page break view. I know how to go to normal view to not see it,
but the problem is this, the 001 prints out on every 1st page I print. If I
print out 3 pages, only page 1 of 3 has a big 001 in the middle of it. I
checked the header and footer to make sure they had no page numbers. Please
help me get the 001 to stop printing! Please!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem printing to PDF mark kubicki Excel Discussion (Misc queries) 1 January 21st 05 06:19 PM
Row Autofit problem Excel 2003 Matthias Klaey Excel Discussion (Misc queries) 0 January 19th 05 05:33 PM
Another (simpler?) printing problem Abi Excel Discussion (Misc queries) 9 January 13th 05 03:50 AM
Paper Tray selection Problem, Michael Hoffmann Excel Discussion (Misc queries) 4 December 3rd 04 09:08 PM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"