Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protect form - embeddin Excel spreadsheet (2003)

    One of our users has a form she created with form fields. She wants to embed part of an Excel spreadsheet in the form. There are 2 problems I need help with. 1) How to lock the embedded spreadsheet so no one can use the mouse and scroll anywhere other than the area we have selected. (2) How to include the unlocked cells in the spreadsheet in the Word document so that when we protect the form in Word, we can still get to the Excel spreadsheet and enter data in the unprotected cells. Is this possible? She doesn't want to use a word table because she said she has some complex formula in the spreadsheet that Word won't recognize.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Protect form - embeddin Excel spreadsheet (2003)

    1) The worksheet can be protected in Excel in the usual way. This is a two-step process:
    a) Unlock the appropriate cells.
    - Select the cells that the user will be allowed to edit.
    - Select Format | Cells...
    - Activate the Protection tab.
    - Clear the Locked check box.
    - Click OK.
    [img]/forums/images/smilies/cool.gif[/img] Protect the worksheet.
    - Select Tools | Protection | Protect Sheet...
    - Tick and clear check boxes to specify what the user will be allowed to do.
    - Click OK.

    2) The worksheet object should be in an unprotected section of the document.
    - If necessary, insert continuous section breaks before and after the Excel object.
    - Activate the Protect Document task pane.
    - Specify that Filling In Forms is allowed.
    - Click Sections... and make sure that the section containing the Excel object will be unprotected.
    - Click Start Enforcing Protection.
    Note: since the worksheet object is in an unprotected section, the user can delete the entire object. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protect form - embeddin Excel spreadsheet (2003)

    Thanks. That works great. Do you have any suggestions how we can keep the user from scrolling to other cells in Excel? Can we lock it somehow so all they can get to is the range we picked to embed into Word?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Protect form - embeddin Excel spreadsheet (2003)

    You can set the column width and the row height to 0 for all columns and rows outside the area you want to make available.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •