Struggling with security question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Wjislt knowing it is impossible to protect a .xls workbook from being copied,
I am trying to find the best route to making it as difficult to the casual
user as I can. I have a comples workbook with code modules.

I understand that if I save this as an Add-in then this will protect it to a
degree but I do not understand how to link the Addin- with the worksheets I
have created link to a workbook with visible worksheets that can be used by
the user without creting all the worksheets again.

Can anyone clarify this or suggest any other means of protecting the file
 
Hi,

You can link add-ins to spreadsheets by setting references to them in the
VBA development environment. Tools - References - Browse & change the file
type you are looking for.

I'm under the impression that all protection of 'straight' Excel development
is ultimately futile to the moderately determined soul.

Regards,

Chris.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA insert column with two workbooks open 1
Storing and Accessing Data 1
detecting a proteced workbook 4
Unprotect Workbook with Function 3
Security 3
Programmaticlly sign and password protect a VBA Project in Excel 2 6
Code to change part of a formula across worksheets 4
Protect workbook 1

Back
Top