+ Reply to Thread
Results 1 to 4 of 4

Locking a table

  1. #1
    Ket
    Guest

    Locking a table

    Hello,

    I am using excel 2003 and have created a small table, 4 colums wide by
    5 rows.
    I have inserted this table as an object into a Microsoft word 2003
    document.
    When I double click this table in Word I have excel functionality,
    unfortunately, it also means that a user can scroll around the table
    and take it out of view. I have hidden the column headers and scroll
    bars.

    Is there a way that this table can be locked so that a user can only
    see the 4x5 table?

    Thanks in advance.

    Ket
    London.

  2. #2
    Ian
    Guest

    Re: Locking a table

    Instead of inserting as an object, copy the relevant cells then paste
    special into Word. You can opt to keep the table linked to the original so
    any change in the original will be reflected, or to break the link for
    static data.

    --
    Ian
    --
    "Ket" <[email protected]> wrote in message
    news:[email protected]...
    > Hello,
    >
    > I am using excel 2003 and have created a small table, 4 colums wide by
    > 5 rows.
    > I have inserted this table as an object into a Microsoft word 2003
    > document.
    > When I double click this table in Word I have excel functionality,
    > unfortunately, it also means that a user can scroll around the table
    > and take it out of view. I have hidden the column headers and scroll
    > bars.
    >
    > Is there a way that this table can be locked so that a user can only
    > see the 4x5 table?
    >
    > Thanks in advance.
    >
    > Ket
    > London.




  3. #3
    Ket
    Guest

    Re: Locking a table

    Ian,

    Thanks for this. What I should have mentiond also is that the user
    will need to open the embedded excel table and change 3 cell values
    before coming out.
    The idea of a linked image file is a good one if it wasn't for this.

    Still greatful for any input - Thanks!


    On Wed, 14 Sep 2005 18:25:58 GMT, "Ian" <[email protected]> wrote:

    >Instead of inserting as an object, copy the relevant cells then paste
    >special into Word. You can opt to keep the table linked to the original so
    >any change in the original will be reflected, or to break the link for
    >static data.
    >
    >--
    >Ian



  4. #4
    Ian
    Guest

    Re: Locking a table

    I can't offer any other suggestions. Sorry.

    --
    Ian
    --
    "Ket" <[email protected]> wrote in message
    news:[email protected]...
    > Ian,
    >
    > Thanks for this. What I should have mentiond also is that the user
    > will need to open the embedded excel table and change 3 cell values
    > before coming out.
    > The idea of a linked image file is a good one if it wasn't for this.
    >
    > Still greatful for any input - Thanks!
    >
    >
    > On Wed, 14 Sep 2005 18:25:58 GMT, "Ian" <[email protected]> wrote:
    >
    >>Instead of inserting as an object, copy the relevant cells then paste
    >>special into Word. You can opt to keep the table linked to the original so
    >>any change in the original will be reflected, or to break the link for
    >>static data.
    >>
    >>--
    >>Ian

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1