We have both Open Office and Microsoft users in our organization. I have constructed a form in Microsoft Excel. The data entry field cells are formatted unprotected, all other cells protected. Sheet Protection is turned on, with "Select Unlocked Cells" activated. The result is that the cursor goes directly to the next unprotected data entry field when the Tab key is pressed. Makes for very efficient data collection.
Using this form in Open Office 2.0, Tab key seems to move the cursor to the protected cell immediately right of the last input, and then to the next unprotected data entry cell, but not always. The unpredictable nature of the beast makes for ghastly data entry. Any suggestions? Jeannie McQuaid, CHRP Supervisor, Human Resources BELSHIELD ENTERPRISES LIMITED ph: (613) 966-3399 Ext. 272 fax: (613) 967-8948 email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
