Click here to Skip to main content
13,045,657 members (66,092 online)
Rate this:
Please Sign up or sign in to vote.
See more:

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,

Posted 10-Oct-11 11:25am

1 solution

Rate this: bad
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.
SCraw2855 10-Oct-11 20:13pm
Good thinking Richard, thank you for the idea.
Richard MacCutchan 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 10 Oct 2011
Copyright © CodeProject, 1999-2017
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