Import Word Form Into Excel

[zulu1ghz]

Hi,

I'm looking for some help as so far I've been unable to do this.

I've created a form in Word which has a number of check boxes. This form works fine once it's been locked, however I've now been asked to incorporate this onto an Excel spreadsheet.

My problem is that in order for me to get it into Excel it has to be unlocked, as a result the check boxes don't work and once it's in Excel i've been unable to find a way to relock the document as it keeps treating it an embeded word document (which it is really I suppose).

Anybody got any suggestions how I can move this from Word and retain the functionality of the check boxes?

All help gratefully received.

Thanks
Steve

 

[sawedoff]

In Excel, when you protect a document, all cells are Locked unless you unlock them. Just unlock the cells that contain a modifyable field. Moving forms from Word to Excel, isn't generally the best route, but can be done if you are willing to reformat most of it. I think you will have to delete the Word checkboxes,and insert Excel checkboxes.

Sawedoff