Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Disable copy function

  1. #11
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if you're covering all the bases, what about preventing copying via the use of an external reference? eg. =[Book1]Sheet1!$A$1

  2. #12
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 21:36, anno wrote:
    if you're covering all the bases, what about preventing copying via the use of an external reference? eg. =[Book1]Sheet1!$A$1
    should be All bases for commandbars.......
    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #13
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    should be All bases for commandbars.......
    sorry ivan, i don't follow (no speak vba). could you explain what you mean please?

  4. #14
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,162
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anno --

    Actually it's possible to decrease the success of that paste link formula approach by encrypting the source file data through a VB application. Or, for a simpler workaround, save the file as a blank template in a dummy file path, or keep it stored in an undisclosed path.

    I agree with the premise of your follow-up: no such thing as absolute security.

    Rumor has it that Thomas Jefferson's actual quote was, "The price of Excel mastery is eternal vigilance."

  5. #15
    Board Regular
    Join Date
    May 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, I do need to cover all the bases. Thanks guys.
    I'm trying to devote more time learning the VB side of Excel, so I may start asking a few more questions. Just been hanging around reading to this point.
    Have a little experience with Access, but that's different animal... My goal here is to protect a template of mine from being too easily duplicated. Am I on the right track or do I need to take another route? Or do I just need to cool it and accept the risk?

  6. #16
    Board Regular
    Join Date
    May 2002
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I answered my last question after working with Tom and Ivan's codes. I don't know you two, but I love you :^)
    Thanks everybody for your time, it's sincerely appreciated.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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