Set permanent print/viewing area?

[jpletting]

I am almost finished creating an order form and (hidden) BOL template
with links between the worksheets to automatically populate the BOL.
This is an order form that I will be sending to customers and I would
like it to look its best when it arrives. Is there a way to specify
the--for lack of a better word--viewing area of a protected document so
they don't see the empty cells to the right and bottom of the form area?
It would also be nice to set the print area permanently so that our
customers (and we, when we get it back) don't need to set it when they
want to print. Is this possible?

 

[Anne Troy]

Protect the Workbook for Windows.
************
Anne Troy
www.OfficeArticles.com

 

[swatsp0p]

You can simply "hide" the unused rows and colums. This will leave a
gray border around your active (or at least used) cells.

Select the uppermost unused row by clicking on it's row number, hold
SHIFT, press END then the _down_ arrow. Right click on the row numbers
and click Hide.

Repeat for the unused columns (END then _right_ arrow)...

HTH

Bruce

 

[Gord Dibben]

Anne

How would that stop users from scrolling out of the viewing area?

jpletting

To prevent users from scrolling around the sheet you could set the Scroll Area
on the sheet through VBA but I would suggest that if you don't want your
customers to access any area but the chosen area you should send only what you
want them to see.

Select the range and copy it as a picture which can be inserted into new
worksheet in a new workbook o a Word document or saved as a graphic or PDF and
sent to them.

Many ways to get a form to your customers without sending them your workbook
which they could access to find data other that what you don't want them to
see.


Gord Dibben Excel MVP