Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Protect a Word Document
- Thread starter PrgrmsAll
- Start date
That depends on how it was "imported". If it was a copy/paste, that makes it just another Word table, and I don't think you can do it. But if it was pasted as a worksheet object (Edit>Paste special), it can be converted to a worksheet object and edited in the document to format cells just like it was an Excel worksheet.
If it was a copy/paste, you can copy it back to Excel, and redone to allow editing. It's a pain, but it beats re-entering the data.
Sawedoff
If it was a copy/paste, you can copy it back to Excel, and redone to allow editing. It's a pain, but it beats re-entering the data.
Sawedoff
It is not easy, and sawedoff has the best suggestion regarding a table brought in from Excel.
As an aside, but somewhat relevant, it IS possible to lock some cells ina Word table, while allowing other cells to be edited. However, it would not be trivial to retro-lock a table from Excel. And, it IS possible to bring Excel data into such a locked/unlocked table in Word, but it could only be done with VBA.
Gerry
As an aside, but somewhat relevant, it IS possible to lock some cells ina Word table, while allowing other cells to be edited. However, it would not be trivial to retro-lock a table from Excel. And, it IS possible to bring Excel data into such a locked/unlocked table in Word, but it could only be done with VBA.
Gerry
- Status
Similar threads
- Locked
- Question
- Locked
- Question