Security - protect code?

  • Thread starter Thread starter sparky3883
  • Start date Start date
S

sparky3883

I was just wondering if anyone could please help me with a query that
am having.

I have created a spreadsheet for work that took a while to do and ha
alot a VB coding in it.

As a few of my collegues are going to be able to use this spreadsheet
i was just wondering if there was anyway of putting some kind o
security feature (password) on my sheet so that the user is unable t
view the coding (just so it can't be changed/deleted). If poss, all
would like the user to do is use the sheet, and i would like to be th
only one who has access to/and can change the coding.

If this possible, and if so, how do i go about setting it up

Many Thank
 
Hi sparky3883!

Select the project in the project explorer window.
Right Click > Properties
Protection Tab
Give and confirm the password.

It should not be regarded as very secure as there are published ways
to circumvent it.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
For "casual" protection against the basically honest but curious,
choosing the VBE's Tools/<project> Properties/Protection item and
checking the Lock project from viewingcheckbox and entering a password
will work (you'll still have free access until you close and reopen the
workbook).

There are, however, a number of crackers out there that will very
cheaply remove project protection. For absolute security, to the extent
that it is possible, you'll want to compile your code in a COM add-in.
 
Are there any tips/ tutorials/readmes that can give a start on how t
"compile your code in a COM add-in."

anybody? :
 
Back
Top