How to allow ink in a protected worksheet?

2
votes

I have an Excel 2003 worksheet with protection enabled being used for data entry on tablet pcs. I'd like to allow users to fill in the contents of the worksheet using ink (and then converting to text), but the ink writing and drawing toolbar is disabled when the worksheet is protected. Is it possible to protect the worksheet and allow ink?

1
excel

1 Answers

4
votes

Sorry to answer my own question, but checking the "Edit Objects" option in the Protect Sheet dialog solved my problem. The equivalent vba was Worksheet.Protect "password" DrawingObjects:=false.