I am wondering if it is possible to have a protected document where you can still edit (change/add figures etc) to an embedded excel object. I am creating a form (template) with fields and tick boxes (in design mode), and for the tick boxes to work, the document must be protected. The people that shall be using the form will be meeting with clients and tabbing between the fields to enter answers to questions, as well as selecting tick boxes and they also need to take financial information, which I thought would be best in an excel object as figures can be added automatically.
I am using Office 2010.
When I protect the document, you are not able to edit the excel spreadsheet. I have selected the cells in the spreadsheet and under Format Cells - Protection - unticked the Locked box, but this has not worked. When protecting the document I have chosen Filling in forms. It is imperative that users are able to tab to each field.
Any help would be very much appreciated! If an embedded excel object is not the answer, do you have any other suggestions?