Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protection vs. copy/paste (2000 SR1)

    I have a spreadsheet that I use to do sales quotes for customers. It contains a column with my cost in it, and another column for markup. I want to hide these two columns, and protect the sheet, so I can e-mail the file to my customers. But anyone can just copy and paste the entire spreadsheet into another blank spreadsheet, and see the hidden columns. Is there a solution to this. I cannot create macros, and I think they would scare my customers anyway. I don't want to delete these two columns every time I do a quote because I'm sure I will forget. Any help is greatly appreciated...Neil

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protection vs. copy/paste (2000 SR1)

    Link your cells to another workbook....
    Put a little hyperlink in your *working* file that takes you to your client version so you can easily see the reflected changes.

    Or you can do the same thing in the workbook and have someone create the code you'd need to have a *Send this worksheet only to client*....

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Brooklyn, New York, USA
    Posts
    176
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protection vs. copy/paste (2000 SR1)

    Another thought is this: instead of mailing your working file to your customers, do a File Save As, give the new file a different name (possibly the customer's name, perhaps impressing the customer), convert the formulas to values in the new version and then delete the two columns of confidential data. Wouldn't take much time at all, avoids macros and links, and protects your data.

    Good luck,

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Protection vs. copy/paste (2000 SR1)

    Excel is not very secure. There are password crackers all over the net for XL files. If I was sending an XL file to a coustomer that contained data that I really didn't want them to see, I would use Cope/Paste Special - Values to convert all formulas to constant values and then delete all data that I didn't want them to see.
    Legare Coleman

Posting Permissions

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