Excel Worksheet Object - Editable in a Word Macro Enabled Document

Question

I have added an excel worksheet object into my macro enabled document. However, once I restrict editing the user cannot edit the excel worksheet in any way. Is there a way to allow edit access to this worksheet? The information that will be edited will only apply to the document and does not have to link back to the source. Is there VBA involved, if so what would that be?

Any help/support would be greatly appreciated! TIA

Answer 1

Hi @Anonymous

From what you have explained the answer is no. When you insert the Excel Worksheet Object and restrict access to the Excel workbook (which is the source) you are therefore restricting their ability to edit that Worksheet. There is no proxy between the worksheet and the document.

You would at the very least have to have some application between the two which is not possible with Excel. Even if you built VBA with a form in Microsoft Word it still would require edit writes to that Excel document (as it would require write access for opening and editing the Excel file).

Hopefully this helps you understand.

--------------------------------------

If this is helpful please accept answer.

Answer 2

Hi @Anonymous

Try the following as a test:

1) Open Microsoft Word

2) Go to Insert > Object > Object

3) Go to Create from file. Then Browse for your file. Then check off Link to file

4) It will add a WorkSheet to your Word document:

5) Restrict your document (as you previously did).

6) Have someone open the file > Right click the worksheet > Linked Object > Open Link.

See if they can edit the file when opening the link and see if it edits it in the Word document.

7) You will then need to update the link:

(or) when you open the file:

(You or the person updating the link will need write access to the Word document).

---

If this is helpful please accept answer.