Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Help with protection of sections of Doc with embedded excel-unprot
Here is my issue.
Using MS Word & Excel 2000 (9.0.6926 SP-3) ISSUE: Unable to open up embedded Excel worksheet in an "unprotected" section of a protected Word document. WHAT I HAVE DONE: I am setting up a document in Word to be used as a template. I have created various section breaks (continuous) within the document. A few of the sections contain form fields. I have copied and pasted (Paste Special as a MS Excel Worksheet Object) a very simple Excel spreadsheet into it's own section of the Word document. I verified within the format section of the Excel sheet that the protection - "lock" box was not selected. I then protected the Word document, selecting the appropriate sections - leaving the section with the Excel sheet "unprotected". RESULT: Unable to open (double click) the Excel worksheet, even though the section is not protected. When I unprotect the entire document, I am able to open the Excel worksheet. Any help to resolve this issue will be greatly appreciated!! Thank you!! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Help with protection of sections of Doc with embedded excel-unprot
Hi ?B?TmVpbCBCYWx0dXM=?=,
Make sure you format the Excel object graphically as "in line with text" (no text wrapping). The entire graphics layer of a protected document is locked, even in unprotected sections. A graphic (Word considers embedded objects to be graphics) must be in-line with the text in order for it to be accessible. Here is my issue. Using MS Word & Excel 2000 (9.0.6926 SP-3) ISSUE: Unable to open up embedded Excel worksheet in an "unprotected" section of a protected Word document. WHAT I HAVE DONE: I am setting up a document in Word to be used as a template. I have created various section breaks (continuous) within the document. A few of the sections contain form fields. I have copied and pasted (Paste Special as a MS Excel Worksheet Object) a very simple Excel spreadsheet into it's own section of the Word document. I verified within the format section of the Excel sheet that the protection - "lock" box was not selected. I then protected the Word document, selecting the appropriate sections - leaving the section with the Excel sheet "unprotected". RESULT: Unable to open (double click) the Excel worksheet, even though the section is not protected. When I unprotect the entire document, I am able to open the Excel worksheet. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Help with protection of sections of Doc with embedded excel-un
Thank you Cindy!!!!!
That worked!!!! "Cindy M." wrote: Hi ?B?TmVpbCBCYWx0dXM=?=, Make sure you format the Excel object graphically as "in line with text" (no text wrapping). The entire graphics layer of a protected document is locked, even in unprotected sections. A graphic (Word considers embedded objects to be graphics) must be in-line with the text in order for it to be accessible. Here is my issue. Using MS Word & Excel 2000 (9.0.6926 SP-3) ISSUE: Unable to open up embedded Excel worksheet in an "unprotected" section of a protected Word document. WHAT I HAVE DONE: I am setting up a document in Word to be used as a template. I have created various section breaks (continuous) within the document. A few of the sections contain form fields. I have copied and pasted (Paste Special as a MS Excel Worksheet Object) a very simple Excel spreadsheet into it's own section of the Word document. I verified within the format section of the Excel sheet that the protection - "lock" box was not selected. I then protected the Word document, selecting the appropriate sections - leaving the section with the Excel sheet "unprotected". RESULT: Unable to open (double click) the Excel worksheet, even though the section is not protected. When I unprotect the entire document, I am able to open the Excel worksheet. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
password protection with sections and track changes | Microsoft Word Help | |||
How do I create multiple sections on one for form protection? | Page Layout | |||
How can I save an embedded Excel file in word back into an Excel | Microsoft Word Help | |||
Spell check stops working half way through a document with unprot. | Microsoft Word Help | |||
Embedded Excel | Microsoft Word Help |