Selecting Print area in protected worksheet
 

I have a worksheet where the users enter data, new rows etc. The calculations
are at the bottom and I have protected them. However, when I do this the
users can no longer set the print area to print. How do I solve this?

Selecting Print area in protected worksheet
 

DRB, I can set the print area with the sheet protected and or the workbook
protected in 2003 with no problems ???
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
I have a worksheet where the users enter data, new rows etc. The
calculations
are at the bottom and I have protected them. However, when I do this the
users can no longer set the print area to print. How do I solve this?

Selecting Print area in protected worksheet
 

Sorry Paul I forgot to mention that I'm using 2002. Will 2002 do this?

"Paul B" wrote:

DRB, I can set the print area with the sheet protected and or the workbook
protected in 2003 with no problems ???
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
I have a worksheet where the users enter data, new rows etc. The
calculations
are at the bottom and I have protected them. However, when I do this the
users can no longer set the print area to print. How do I solve this?

Selecting Print area in protected worksheet
 

Sorry Paul. I forgot to mention that I am using 2002. Does 2002 allow you to
do this?

"Paul B" wrote:

DRB, I can set the print area with the sheet protected and or the workbook
protected in 2003 with no problems ???
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
I have a worksheet where the users enter data, new rows etc. The
calculations
are at the bottom and I have protected them. However, when I do this the
users can no longer set the print area to print. How do I solve this?

Selecting Print area in protected worksheet
 

DRB, I would think it would, will check on my computer at home with 2002
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
Sorry Paul. I forgot to mention that I am using 2002. Does 2002 allow you
to
do this?

"Paul B" wrote:

DRB, I can set the print area with the sheet protected and or the
workbook
protected in 2003 with no problems ???
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
I have a worksheet where the users enter data, new rows etc. The
calculations
are at the bottom and I have protected them. However, when I do this
the
users can no longer set the print area to print. How do I solve this?

Selecting Print area in protected worksheet
 

DRB, works OK for me in 2002 also

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Paul B" wrote in message
...
DRB, I would think it would, will check on my computer at home with 2002
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
Sorry Paul. I forgot to mention that I am using 2002. Does 2002 allow
you
to
do this?

"Paul B" wrote:

DRB, I can set the print area with the sheet protected and or the
workbook
protected in 2003 with no problems ???
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"DRB" wrote in message
...
I have a worksheet where the users enter data, new rows etc. The
calculations
are at the bottom and I have protected them. However, when I do this
the
users can no longer set the print area to print. How do I solve this?