+ Reply to Thread
Results 1 to 6 of 6

Add comments without deleting.

  1. #1
    Paperback Writer
    Guest

    Add comments without deleting.

    Hello - We are having trouble with users adding/overwriting comments made in
    a cell.

    Is there a way to allow users to type in a cell, but not delete? I know
    that Excel 2002 has a function that works like this, but we are on 2000.
    Does anyone have the VBA to do this?

  2. #2
    Don Guillett
    Guest

    Re: Add comments without deleting.

    what would the original look like
    what typed in
    what would the final look like

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Paperback Writer" <[email protected]> wrote in
    message news:[email protected]...
    > Hello - We are having trouble with users adding/overwriting comments made
    > in
    > a cell.
    >
    > Is there a way to allow users to type in a cell, but not delete? I know
    > that Excel 2002 has a function that works like this, but we are on 2000.
    > Does anyone have the VBA to do this?




  3. #3
    Paperback Writer
    Guest

    Re: Add comments without deleting.

    Original: Account adjusted, looking into mismatched order 123456.

    Type in: Checking with accounting.

    Look like: Account adjusted, looking into mismatched order 123456. Checking
    with accounting.

    The way it is now, the "original" text gets deleted.


    "Don Guillett" wrote:

    > what would the original look like
    > what typed in
    > what would the final look like
    >
    > --
    > Don Guillett
    > SalesAid Software
    > [email protected]
    > "Paperback Writer" <[email protected]> wrote in
    > message news:[email protected]...
    > > Hello - We are having trouble with users adding/overwriting comments made
    > > in
    > > a cell.
    > >
    > > Is there a way to allow users to type in a cell, but not delete? I know
    > > that Excel 2002 has a function that works like this, but we are on 2000.
    > > Does anyone have the VBA to do this?

    >
    >
    >


  4. #4
    Don Guillett
    Guest

    Re: Add comments without deleting.

    The simple way would be to touch the f2 key and start typing

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Paperback Writer" <[email protected]> wrote in
    message news:[email protected]...
    > Original: Account adjusted, looking into mismatched order 123456.
    >
    > Type in: Checking with accounting.
    >
    > Look like: Account adjusted, looking into mismatched order 123456.
    > Checking
    > with accounting.
    >
    > The way it is now, the "original" text gets deleted.
    >
    >
    > "Don Guillett" wrote:
    >
    >> what would the original look like
    >> what typed in
    >> what would the final look like
    >>
    >> --
    >> Don Guillett
    >> SalesAid Software
    >> [email protected]
    >> "Paperback Writer" <[email protected]> wrote in
    >> message news:[email protected]...
    >> > Hello - We are having trouble with users adding/overwriting comments
    >> > made
    >> > in
    >> > a cell.
    >> >
    >> > Is there a way to allow users to type in a cell, but not delete? I
    >> > know
    >> > that Excel 2002 has a function that works like this, but we are on
    >> > 2000.
    >> > Does anyone have the VBA to do this?

    >>
    >>
    >>




  5. #5
    Paperback Writer
    Guest

    Re: Add comments without deleting.

    I'm afraid that won't work. The end users just tab to the field and start
    typing. Then it's, "Oooops."

    Other ideas?


    "Don Guillett" wrote:

    > The simple way would be to touch the f2 key and start typing
    >
    > --
    > Don Guillett
    > SalesAid Software
    > [email protected]
    > "Paperback Writer" <[email protected]> wrote in
    > message news:[email protected]...
    > > Original: Account adjusted, looking into mismatched order 123456.
    > >
    > > Type in: Checking with accounting.
    > >
    > > Look like: Account adjusted, looking into mismatched order 123456.
    > > Checking
    > > with accounting.
    > >
    > > The way it is now, the "original" text gets deleted.
    > >
    > >
    > > "Don Guillett" wrote:
    > >
    > >> what would the original look like
    > >> what typed in
    > >> what would the final look like
    > >>
    > >> --
    > >> Don Guillett
    > >> SalesAid Software
    > >> [email protected]
    > >> "Paperback Writer" <[email protected]> wrote in
    > >> message news:[email protected]...
    > >> > Hello - We are having trouble with users adding/overwriting comments
    > >> > made
    > >> > in
    > >> > a cell.
    > >> >
    > >> > Is there a way to allow users to type in a cell, but not delete? I
    > >> > know
    > >> > that Excel 2002 has a function that works like this, but we are on
    > >> > 2000.
    > >> > Does anyone have the VBA to do this?
    > >>
    > >>
    > >>

    >
    >
    >


  6. #6
    Don Guillett
    Guest

    Re: Add comments without deleting.

    Hit there little fingers with a big hammer.

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "Paperback Writer" <[email protected]> wrote in
    message news:[email protected]...
    > I'm afraid that won't work. The end users just tab to the field and start
    > typing. Then it's, "Oooops."
    >
    > Other ideas?
    >
    >
    > "Don Guillett" wrote:
    >
    >> The simple way would be to touch the f2 key and start typing
    >>
    >> --
    >> Don Guillett
    >> SalesAid Software
    >> [email protected]
    >> "Paperback Writer" <[email protected]> wrote in
    >> message news:[email protected]...
    >> > Original: Account adjusted, looking into mismatched order 123456.
    >> >
    >> > Type in: Checking with accounting.
    >> >
    >> > Look like: Account adjusted, looking into mismatched order 123456.
    >> > Checking
    >> > with accounting.
    >> >
    >> > The way it is now, the "original" text gets deleted.
    >> >
    >> >
    >> > "Don Guillett" wrote:
    >> >
    >> >> what would the original look like
    >> >> what typed in
    >> >> what would the final look like
    >> >>
    >> >> --
    >> >> Don Guillett
    >> >> SalesAid Software
    >> >> [email protected]
    >> >> "Paperback Writer" <[email protected]> wrote
    >> >> in
    >> >> message news:[email protected]...
    >> >> > Hello - We are having trouble with users adding/overwriting comments
    >> >> > made
    >> >> > in
    >> >> > a cell.
    >> >> >
    >> >> > Is there a way to allow users to type in a cell, but not delete? I
    >> >> > know
    >> >> > that Excel 2002 has a function that works like this, but we are on
    >> >> > 2000.
    >> >> > Does anyone have the VBA to do this?
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




+ 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