+ Reply to Thread
Results 1 to 5 of 5

How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

  1. #1
    Dan E
    Guest

    How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

    I want to prevent users from MOVING, CUTTING or DELETING data cells (which
    would cause any reference to that cell to give an error), but allow them to
    clear the contents of the cell and enter new values (in other words, be able
    to edit the cell). Any suggestions VERY welcome.

    TIA,

    Dan

    --
    Dan E
    webbie(removethis)@preferredcountry.com



  2. #2
    Kevin
    Guest

    Re: How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

    Dan E (removethis) wrote:
    > I want to prevent users from MOVING, CUTTING or DELETING data cells

    (which
    > would cause any reference to that cell to give an error), but allow

    them to
    > clear the contents of the cell and enter new values (in other words,

    be able
    > to edit the cell). Any suggestions VERY welcome.
    >
    > TIA,
    > Dan


    I posted a similar question recently ...
    Max's solution has worked perfectly for me. See this thread :

    http://groups-beta.google.com/group/...148b91e9862df5


  3. #3
    Dan E
    Guest

    Re: How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

    Kevin - interesting way to do this, but not an option for me. Thanks
    anyway.

    dan
    "Kevin" <kdiggins@gmail.com> wrote in message
    news:1111943601.277588.229120@g14g2000cwa.googlegroups.com...
    > Dan E (removethis) wrote:
    >> I want to prevent users from MOVING, CUTTING or DELETING data cells

    > (which
    >> would cause any reference to that cell to give an error), but allow

    > them to
    >> clear the contents of the cell and enter new values (in other words,

    > be able
    >> to edit the cell). Any suggestions VERY welcome.
    >>
    >> TIA,
    >> Dan

    >
    > I posted a similar question recently ...
    > Max's solution has worked perfectly for me. See this thread :
    >
    > http://groups-beta.google.com/group/...148b91e9862df5
    >




  4. #4
    Ken Wright
    Guest

    Re: How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

    See your other post for another possible approach.

    --
    Regards
    Ken....................... Microsoft MVP - Excel
    Sys Spec - Win XP Pro / XL 97/00/02/03

    ----------------------------------------------------------------------------
    It's easier to beg forgiveness than ask permission :-)
    ----------------------------------------------------------------------------

    "Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
    news:ei8Q$LuMFHA.3760@TK2MSFTNGP12.phx.gbl...
    > I want to prevent users from MOVING, CUTTING or DELETING data cells (which
    > would cause any reference to that cell to give an error), but allow them

    to
    > clear the contents of the cell and enter new values (in other words, be

    able
    > to edit the cell). Any suggestions VERY welcome.
    >
    > TIA,
    >
    > Dan
    >
    > --
    > Dan E
    > webbie(removethis)@preferredcountry.com
    >
    >




  5. #5
    Dan E
    Guest

    Re: How do I allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?

    Ken - see my reply in my previous post.

    Dan
    "Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
    news:eGVKSB4MFHA.3340@TK2MSFTNGP14.phx.gbl...
    > See your other post for another possible approach.
    >
    > --
    > Regards
    > Ken....................... Microsoft MVP - Excel
    > Sys Spec - Win XP Pro / XL 97/00/02/03
    >
    > ----------------------------------------------------------------------------
    > It's easier to beg forgiveness than ask permission :-)
    > ----------------------------------------------------------------------------
    >
    > "Dan E" <webbie(removethis)@preferredcountry.com> wrote in message
    > news:ei8Q$LuMFHA.3760@TK2MSFTNGP12.phx.gbl...
    >> I want to prevent users from MOVING, CUTTING or DELETING data cells
    >> (which
    >> would cause any reference to that cell to give an error), but allow them

    > to
    >> clear the contents of the cell and enter new values (in other words, be

    > able
    >> to edit the cell). Any suggestions VERY welcome.
    >>
    >> TIA,
    >>
    >> Dan
    >>
    >> --
    >> Dan E
    >> webbie(removethis)@preferredcountry.com
    >>
    >>

    >
    >




+ 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