dll's - for passwords

daveray · Mar 30th, 2002, 02:45 AM

Can anyone help me with password protection of a sheet using VBE and dll's please?

I have searched the site but cannot find anything to help me. Excel passwords are too easy to defeat and I want to prevent the work being copied or passed on to a 3rd party.

Having spent hundreds of hours entering data I don't want it copied by someone who was too lazy to help me construct it. I will share the work with the people who contributed but it would be easy for someone in the office to pirate a copy and then distribute it as their own work.

If a coder can help me for a reasonable fee that i am willing to talk.

Thanks in anticipation

Dave

Jack in the UK · Mar 30th, 2002, 03:07 AM

hi--

yes i totally understand and agree with you, them that take eh! them not putting the time in to develop excel..

however the idea is to help not obstruct, so try to help if you can... OK back to you question

am reliably advised that this can be done by dll file in system reg... so you need systen reg file to open the xls file else it fails.

also the dll is a copy of your code or that s my iead so if coded edited then its not going to open...

i have never really solved this but your never stop someone copying stealing a xls file, but stop them editing you can im sure.

to do this dll files are C++ or VB scripts compliled into machine codes you know 0101000101001 all that stuff

i wanted a hiddedn script in vbe that checks for alterations.

remember you can pw moduels and stop save as.. but removing that option, suppose can make save as need a password to carry out that instruction..

have a think.. but try to help others even if like me they take libertys and annoy you.. they know not what they do...

smozgur · Mar 30th, 2002, 03:48 AM

Hi daveray,

COM Addins would solve your problem easily which Jack mentioned above. We are creating this kind of special applications if you are interested. Changing your current works to this COM addins and also avoid reusing without some procedures or some other possible requests of yours.

Please visit us for more information
regards

Jack in the UK · Mar 30th, 2002, 04:52 AM

also yes please can you email to my hotmail in profile

thank you very much alway inttrested in this

Mar 30th, 2002, 03:07 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	hi-- yes i totally understand and agree with you, them that take eh! them not putting the time in to develop excel.. however the idea is to help not obstruct, so try to help if you can... OK back to you question am reliably advised that this can be done by dll file in system reg... so you need systen reg file to open the xls file else it fails. also the dll is a copy of your code or that s my iead so if coded edited then its not going to open... i have never really solved this but your never stop someone copying stealing a xls file, but stop them editing you can im sure. to do this dll files are C++ or VB scripts compliled into machine codes you know 0101000101001 all that stuff i wanted a hiddedn script in vbe that checks for alterations. remember you can pw moduels and stop save as.. but removing that option, suppose can make save as need a password to carry out that instruction.. have a think.. but try to help others even if like me they take libertys and annoy you.. they know not what they do... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Mar 30th, 2002, 04:52 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	also yes please can you email to my hotmail in profile thank you very much alway inttrested in this __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 30th, 2002, 02:45 AM	#1
daveray New Member Join Date: Mar 2002 Posts: 28	Can anyone help me with password protection of a sheet using VBE and dll's please? I have searched the site but cannot find anything to help me. Excel passwords are too easy to defeat and I want to prevent the work being copied or passed on to a 3rd party. Having spent hundreds of hours entering data I don't want it copied by someone who was too lazy to help me construct it. I will share the work with the people who contributed but it would be easy for someone in the office to pirate a copy and then distribute it as their own work. If a coder can help me for a reasonable fee that i am willing to talk. Thanks in anticipation Dave

Mar 30th, 2002, 03:48 AM	#3
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Hi daveray, COM Addins would solve your problem easily which Jack mentioned above. We are creating this kind of special applications if you are interested. Changing your current works to this COM addins and also avoid reusing without some procedures or some other possible requests of yours. Please visit us for more information regards