i have grappled w/ this for some time. i create programs that use excel
spreasheets as input sheets, have vba code in modules called w/ buttons,
then use excel spreadsheets as output (pretty typical of this group i would
guess).
my problem is i have noticed people copying these files to friends, etc. and
i would like to prevent this. i envision something like:
sub MainCode()
if computerID = 12983746abg12 then 'this is the key
else
msgbox "this code not allowed on this particular computer"
end
end if
'code here
end sub

the catch here is: is there a serial number, computer ID, or something that
is unique and not easily changed w/in each individual computer? you can
even assume nothing but stand alone pc's.
any other thoughts if this is not possible? thanks, mike allen