+ Reply to Thread
Results 1 to 5 of 5

allow me to copy and paste in a protected worksheet

  1. #1
    George
    Guest

    allow me to copy and paste in a protected worksheet

    I have a password-protected worksheet. How could I copy and paste
    within the same worksheet without unprotected it? Any help will be
    highly appreciated! Thanks,


  2. #2
    Ron de Bruin
    Guest

    Re: allow me to copy and paste in a protected worksheet

    See


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "George" <[email protected]> wrote in message news:[email protected]...
    >I have a password-protected worksheet. How could I copy and paste
    > within the same worksheet without unprotected it? Any help will be
    > highly appreciated! Thanks,
    >




  3. #3
    Ron de Bruin
    Guest

    Re: allow me to copy and paste in a protected worksheet


    Hi George

    If you unlock the destenation cells then you can copy paste when you protect a sheet


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
    > See
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "George" <[email protected]> wrote in message news:[email protected]...
    >>I have a password-protected worksheet. How could I copy and paste
    >> within the same worksheet without unprotected it? Any help will be
    >> highly appreciated! Thanks,
    >>

    >
    >




  4. #4
    George
    Guest

    Re: allow me to copy and paste in a protected worksheet

    Thanks for your response. Please let me take this chance to state my
    question more clearly. In my worksheet, I have a column with all cells
    in that column locked (IT IS A MUST. I CAN NOT UNLOCK ANY CELL IN THAT
    COLUMN AND THEN PROTECT THE WORKSHEET). There are a few cells UNDER
    OTHER COLUMNS unlocked for user to input their data. Then the whole
    worksheet is password-protected. My question is how to allow user to
    copy one ROW and paste it into another row without unprotect the
    worksheet? Please keep it in mind that there is at least one cell in
    EACH ROW locked where user CAN NOT modify the value in that cell.
    Thanks and I am looking forward to hearing from you soon!
    ********************************************************************************************************************

    Ron de Bruin wrote:
    > Hi George
    >
    > If you unlock the destenation cells then you can copy paste when you protect a sheet
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
    > > See
    > >
    > >
    > > --
    > > Regards Ron de Bruin
    > > http://www.rondebruin.nl
    > >
    > >
    > >
    > > "George" <[email protected]> wrote in message news:[email protected]...
    > >>I have a password-protected worksheet. How could I copy and paste
    > >> within the same worksheet without unprotected it? Any help will be
    > >> highly appreciated! Thanks,
    > >>

    > >
    > >



  5. #5
    Registered User
    Join Date
    04-08-2010
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: allow me to copy and paste in a protected worksheet

    i'm also looking 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