Printing Problem: get the 001 to stop printing!

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!

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"
<kimmyrt@discussions.microsoft.com> 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!

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"
> <kimmyrt@discussions.microsoft.com> 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!
>
>

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"
> > <kimmyrt@discussions.microsoft.com> 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!
> >
> >