Elchanan schrieb:
Hi everyone,
Running Win XP PRO. I am creating a spreadsheet-based form, a single worksheet. I need to
distribute to a variety of people, some of whom will not have OO, so the
form must go out as an xls file. I created the form using Excel, locked all the cells, unlocked the data
entry cells, and protected the spreadsheet. Works fine in Excel, you can
only click in the data entry cells. But when I open this form using Calc, while you cannot enter data in the
locked cells, you CAN click in them. So a user cannot simply go tab tab tab
through the data entry cells and nothing else.

Calc does not support to prevent clicking locked cells, but in protected sheets, the TAB key will travel through all unlocked cells and skip the locked cells. What are you doing exactly?


Regards
Daniel

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to