Protecting my work

[daveray]

I have spent hundreds of hours writing a spreadsheet for calculating job times and costs. Entering the product details and costs was particularly soul destroying.

Anyway, I don't want some lazy good for nothing from my office copying my work and then spreading it around as his work! I will share the sheet with those who have helped (thankfully we do have some team players) but I need to protect it with a password.

I can't use the password protection in Excel as that is easily defeated. Is there a way to distribute this sheet and code it in VB Editor with a unique password? My obvious concern is that someone will pass it on along with their password and then I have been duped.

Any ideas?

Dave
This message was edited by daveray on 2002-03-28 04:42

 

[eliW]

On 2002-03-28 04:42, daveray wrote:
I have spent hundreds of hours writing a spreadsheet for calculating job times and costs. Entering the product details and costs was particularly soul destroying.

Anyway, I don't want some lazy good for nothing from my office copying my work and then spreading it around as his work! I will share the sheet with those who have helped (thankfully we do have some team players) but I need to protect it with a password.

I can't use the password protection in Excel as that is easily defeated. Is there a way to distribute this sheet and code it in VB Editor with a unique password? My obvious concern is that someone will pass it on along with their password and then I have been duped.

Any ideas?

Dave
This message was edited by daveray on 2002-03-28 04:42

http://www.mrexcel.com/board/viewtopic.php?topic=3193&forum=2
Eli