software

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?

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 amp; 2003

quot;DRBquot; gt; wrote in message
...
gt;I have a worksheet where the users enter data, new rows etc. The
gt;calculations
gt; are at the bottom and I have protected them. However, when I do this the
gt; users can no longer set the print area to print. How do I solve this?
Sorry Paul I forgot to mention that I'm using 2002. Will 2002 do this?

quot;Paul Bquot; wrote:

gt; DRB, I can set the print area with the sheet protected and or the workbook
gt; protected in 2003 with no problems ???
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;DRBquot; gt; wrote in message
gt; ...
gt; gt;I have a worksheet where the users enter data, new rows etc. The
gt; gt;calculations
gt; gt; are at the bottom and I have protected them. However, when I do this the
gt; gt; users can no longer set the print area to print. How do I solve this?
gt;
gt;
gt;

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

quot;Paul Bquot; wrote:

gt; DRB, I can set the print area with the sheet protected and or the workbook
gt; protected in 2003 with no problems ???
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;DRBquot; gt; wrote in message
gt; ...
gt; gt;I have a worksheet where the users enter data, new rows etc. The
gt; gt;calculations
gt; gt; are at the bottom and I have protected them. However, when I do this the
gt; gt; users can no longer set the print area to print. How do I solve this?
gt;
gt;
gt;

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 amp; 2003

quot;DRBquot; gt; wrote in message
news
gt; Sorry Paul. I forgot to mention that I am using 2002. Does 2002 allow you
gt; to
gt; do this?
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt;gt; DRB, I can set the print area with the sheet protected and or the
gt;gt; workbook
gt;gt; protected in 2003 with no problems ???
gt;gt; --
gt;gt; Paul B
gt;gt; Always backup your data before trying something new
gt;gt; Please post any response to the newsgroups so others can benefit from it
gt;gt; Feedback on answers is always appreciated!
gt;gt; Using Excel 2002 amp; 2003
gt;gt;
gt;gt; quot;DRBquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have a worksheet where the users enter data, new rows etc. The
gt;gt; gt;calculations
gt;gt; gt; are at the bottom and I have protected them. However, when I do this
gt;gt; gt; the
gt;gt; gt; users can no longer set the print area to print. How do I solve this?
gt;gt;
gt;gt;
gt;gt;
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 amp; 2003

quot;Paul Bquot; gt; wrote in message
...
gt; DRB, I would think it would, will check on my computer at home with 2002
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;DRBquot; gt; wrote in message
gt; news
gt; gt; Sorry Paul. I forgot to mention that I am using 2002. Does 2002 allow
you
gt; gt; to
gt; gt; do this?
gt; gt;
gt; gt; quot;Paul Bquot; wrote:
gt; gt;
gt; gt;gt; DRB, I can set the print area with the sheet protected and or the
gt; gt;gt; workbook
gt; gt;gt; protected in 2003 with no problems ???
gt; gt;gt; --
gt; gt;gt; Paul B
gt; gt;gt; Always backup your data before trying something new
gt; gt;gt; Please post any response to the newsgroups so others can benefit from
it
gt; gt;gt; Feedback on answers is always appreciated!
gt; gt;gt; Using Excel 2002 amp; 2003
gt; gt;gt;
gt; gt;gt; quot;DRBquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have a worksheet where the users enter data, new rows etc. The
gt; gt;gt; gt;calculations
gt; gt;gt; gt; are at the bottom and I have protected them. However, when I do this
gt; gt;gt; gt; the
gt; gt;gt; gt; users can no longer set the print area to print. How do I solve this?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;