I am stumped on this one. I have a workbook with three sheets; one is a
general input screen used to gather specific data relative to a business plan
and is also used to perform calculations on the other two sheets. The second
sheet is used to input job specific information and uses information from the
first sheet to perform calculations. The final sheet is a repository of the
overall calculations. On the first two sheets, I have used conditional
formats to indicate which fields require input from the user. I have also
protected the sheets and workbook in addition to hiding the third sheet.
Sheet 2 works fine; however, on sheet one, the cursor does not move. I can
manually click to the next field for input, but it is not "obvious" that the
cell is selected. On several occassions, the file has locked up (for hours!)
and I had to CTL+ALT+DEL to start over. The cursor moves just fine on sheet
2. What should I be looking for to resolve this problem?