Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Prevent Copy (MS Excel 2003)

    Hi all,

    Is there a way to allow others to have read and write access to certain part of spreadsheet and yet it doesn't allow them to copy any part or the whole spreadsheet to another workbook / worksheet?

    I was going through the Help section but can't find anything on this subject.

    cheers, francis
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

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

    Re: Prevent Copy (MS Excel 2003)

    No. If they can edit part of a worksheet, they can also copy cells from that part to the clipboard. You can prevent users from selecting - and hence copying - locked parts of a worksheet.

Posting Permissions

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