Hope someone can help me out with these 2 issues:

(1st Problem)

I have a spreadsheet that in one section has Part Numbers , Assembly
ID, Q/A Code, Quantity, Production Tag # ...... and so on ad nauseam.

A1:Q34

Right now I manually insert a new line for each new part number and
this is tedious when a project might have 200 lines to be entered and
error checked.

Is there not a way using vba to do a carriage return/line feed instead
of the good but mind numbing manual way.

--------------------------------------------------------------------------------------------------------

( 2nd Problem )

The same spreadsheet is sent to other people and signed but some areas
I have protected so they can be viewed but not inadvertently altered.
What I would like to do is set the scroll area automatically so people
can tab from one place to the other and enter their names and comments
as required.

As the spreadsheet varies in depth according to the number of parts
entered I don't seem to be able to set the scroll area to increase or
decrease accordingly.


Thank you in advance for any pointers you might toss my way.


--
ZimBoy
------------------------------------------------------------------------
ZimBoy's Profile: http://www.excelforum.com/member.php...o&userid=24273
View this thread: http://www.excelforum.com/showthread...hreadid=378906