Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VBA script
Greetings,
 
I'm having a difficult time trying to accomplish a task that involves non techfriendly individuals.
 
My issue is this;   I was tasked to create an action similar to that of copyright protection for an Excel workbook that he wants to share, but he wants them to agree to "not sharing" the information located within.   If they do not agree then he doesn't want them to open it.
 
I considered using scripts that would call the Excel sheet from a network directory, but we have restrictions on passing around executable files, and some of the people are not located in our intranet.
 
Can this be accomplished using a workbook via macros?   Is this even possible, as even CodeProject's Archives and articles/Google/Technet/ and my mother didn't appear to lead me anywhere but into a face palm?
 
Mt other thought was using HTML, but I think that he wants them to be able to change some of results to see if the formulas work correctly, and my HTML is akin to the running ability of a 3-peckered billy goat...
 
Thank you for your time,
 
Steve
Posted 10-Oct-11 12:25pm
SCraw28551.5K

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

My suggestion would be to add a Auto_open VBA macro which offers the copyright notice as a dialog. The user then has the choice to click on Accept or Reject, and if not Accept the macro automatically closes the worksheet. Of course, this is not foolproof, but it is at least good enough to make honest people consider their actions.
  Permalink  
Comments
SCraw2855 at 10-Oct-11 20:13pm
   
Good thinking Richard, thank you for the idea.
Richard MacCutchan at 11-Oct-11 4:04am
   
Happy to help.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Marcin Kozub 330
1 OriginalGriff 256
2 Sergey Alexandrovich Kryukov 215
3 Praneet Nadkar 197
4 Richard MacCutchan 182
0 OriginalGriff 8,048
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 10 Oct 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100