Printing Worksheet with Protected Cells

External Since: May 10, 2006 Posts: 30

Hello,

We have an Excel 2003 spreadsheet and many of the cells are protected. The
problem is, when we can't set the print area or do anything else to select
parts of the page which include the protected cells.

In the spreadsheet, we are always selecting different areas to print so
there is nothing static about what we are printing.

Can anyone help?

Thanks!

LDMueller

External Since: Feb 23, 2004 Posts: 8275

You can always go to File>Page Setup>Sheet and type in a print range even if you
cannot select cells.

Gord Dibben MS Excel MVP

On Fri, 4 Apr 2008 08:34:04 -0700, LDMueller
<LDMueller DeleteThis @discussions.microsoft.com> wrote:

>Hello,
>
>We have an Excel 2003 spreadsheet and many of the cells are protected. The
>problem is, when we can't set the print area or do anything else to select
>parts of the page which include the protected cells.
>
>In the spreadsheet, we are always selecting different areas to print so
>there is nothing static about what we are printing.
>
>Can anyone help?
>
>Thanks!
>
>LDMueller
>