Using a tool like Teamviewer, can I safely let a programmer add code without risk of him/her downloading my document?

Using a tool like Teamviewer, can I safely let a programmer add code without risk of him/her downloading my document?

Or any other tool. The main thing is to all the time be certain the programmer can work on my document (Excel workbook) and add VBA code without any risk that he/she downloads the workbook. Could I even restrict viewing of certain pages, tabs and cells/cell areas of this workbook and perhaps let several different programmers work on different tabs of my Excel workbook? Although they might take a screencast of the tabs, but if I divide the task on several programmers and restrict viewing I would neutralize this risk also.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dr. KlahnPrincipal Software EngineerCommented:
If the remote user can see your code and documents, he can save it to his system by simply taking screenshots.

Trying to divide a project up into several different sections when it is not absolutely necessary is counterproductive and adds unnecessary cost and complications.  As Brooks says in "The Mythical Man-Month" -- "Adding manpower to a late software project makes it later."
Shaun VermaakTechnical SpecialistCommented:
Are you going to sit and watch everything they do?
Roy CoxGroup Finance ManagerCommented:
Why would he need to work on your computer to provide VBA code? It can easily be done without access to your computer

1. He/she could create a dummy workbook with the same layout as your workbook. You could provide this.
2. Depending on what the code does he/she could create an addin to contain the code.

I've been coding for almost twenty years and never needed access to the end user's computer.

Trusting the developer depends on how you found the developer and what their qualifies them to be the person to use.
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Shaun VermaakTechnical SpecialistCommented:
If you need a developer to help with VBA development, you probably need one to split the code
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
You have no control over that. You can disallow file transfer, record videos and/or watch what is been done in a remote session, but that's it.
A programmer needs to know a lot about the environment the code has to run in (a big issue with coding here on EE). Cutting of access usually leads to bad code or long development time. Not having any trust doesn't help with that - you need a certain amount of trust, otherwise it's futile.
hermesalphaAuthor Commented:
Then I think the safest for me would be, before handing over the Excel workbook to one programmer only, to alter most values in the workbook. This whole workbook is highly dependent on these values to be of any value at all. If these values are not correct, it will require enormous efforts to find out the correct values. I could even alter the headings so the programmer doesn't know what the values refer to (because of the subject area it would still not be of any help for the programmer to have the correct headings to refer to; these headings are only valuable when this Excel workbook is used for its purpose).

When I finally receive the completed workbook from the programmer, I just change back to correct values and correct headings.
Roy CoxGroup Finance ManagerCommented:
It seems strange that you don't trust the developer with access or actual data but trust his code.
Gustav BrockCIOCommented:
You can't.
The procedure is:

  • Use a developer you trust
  • Tell the developer what is confident and what is not (if anything)
  • Let the developer explain how he/she will take care of your confidential stuff
  • Require that the developer signs an NDA. This is common, and even mandatory for all large corporations

You can browse for ready-made NDAs that you easily can adjust to your situation.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
David FavorLinux/LXD/WordPress/Hosting SavantCommented:
As Gustav said, the answer is no.

If someone can work on a document, they can download the contents in many ways.

Follow Gustav's suggestion, especially his first item - Use a developer you trust.
Gustav BrockCIOCommented:
Options and procedure described.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.