VBA Coding Trick

[sam99]

Hi,

I want to know if there is any trick or tip to make my code look
complicated or hard to understand or a way to re-write or add to th
code more lines so no one can take my work. My manager wants me to kee
the code open and show it to my colleagues. Although, we don’t work i
programming we are in a totally different field. Anyway, long stor
short I need to make the code complicated “just looking hard to read
until I finish the program so no one steal my Idea.

Than

 

[Vacuum Sealed]

Hi,

I want to know if there is any trick or tip to make my code looks
complicated or hard to understand or a way to re-write or add to the
code more lines so no one can take my work. My manager wants me to keep
the code open and show it to my colleagues. Although, we don’t work in
programming we are in a totally different field. Anyway, long story
short I need to make the code complicated “just looking hard to read”
until I finish the program so no one steal my Idea.

Thanx

Hi

Well, for those in your company who have no idea of workbook protection
and how to easily crack it you could try that, conversely any good
knowledgeable programmer will have it cracked within a couple of minutes
using a 3rd party hack program ( like the one I use on files that have
been created by others long gone from the company ) which need some
tweaking and T.L.C.

I would be careful of what you are doing though, you may want to go back
to your employment contract/agreement and see if there is a clause
pertaining to intellectual property whilst in their employ.

Many companies write it in to protect themselves and to ensure anything
that is created on their paying time belongs to them, regardless. My
contract has such a clause and I work for a transport company, not a
blue-chip investment or programming development organization.

Any good programmer regardless of the field, will/should be able to read
through code to ascertain it's function and in all likelihood, shorten
it to his/her level if they're in the Guru category.

HTH
Mick.

 

[Peter T]

The term you are probably looking for is obfuscate or obfuscation. Try
searching together with VBA and perhaps Excel.

In essence, replace all variable names with meaningless characters. You can
do it manually though there are addins out there which purport to do it all
automatically.

Regards,
Peter T

 

[RB Smissaert]

A good option is to get VB6 and move code to a VB6 activeX dll.
Coding is very similar to VBA and nobody can see your code.
Still should be available on things like eBay.

RBS

 

[Auric__]

I want to know if there is any trick or tip to make my code looks
complicated or hard to understand or a way to re-write or add to the
code more lines so no one can take my work. My manager wants me to keep
the code open and show it to my colleagues. Although, we don’t work in
programming we are in a totally different field. Anyway, long story
short I need to make the code complicated “just looking hard to read”
until I finish the program so no one steal my Idea.

Switch to a different language, one that none of them knows and would never
understand. Malebolge or Befunge or Brainf*ck or...

 

[sam99]

Thanx everyone these Ideas are really helpfu