Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem printing to PDF | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Another (simpler?) printing problem | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |