Re: Add-in with excel
- From: "Bob" <someonw@xxxxxx>
- Date: Mon, 11 Feb 2008 11:37:56 -0800
Thanks Brian. I will try that. I thought that the only way of securing
excel is by password, but I wanted to make sure.
Bob
<bmurphy@xxxxxxxxxxx> wrote in message
news:d7d3e300-214b-4914-9c3b-da2a66bd478d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
From the excel user interface go File/Save As and in the dialog
select "add-in" as the file type. This will save the file with an XLA
extension.
Then go to VBA and in the Project tree right click on the file and
select Properties. In here set "Lock for viewing" and give it a
password.
This is as secure as you can make it in Excel. But readily available
Office password crackers can defeat this. The casual user, however,
won't be able to see your code.
To make it really secure, I believe you have to port the code to VB6,
and compile it into what I think is called a COM file. I've never
done this myself, but it might actually be pretty easy. Use Google to
find an example VB6 project that shows how it's done.
Good luck,
Brian Murphy
Austin, Texas
.
- References:
- Re: Add-in with excel
- From: bmurphy
- Re: Add-in with excel
- Prev by Date: Excel application very slow after loading xla
- Next by Date: VBA to SQL Stored Procedure function
- Previous by thread: Re: Add-in with excel
- Next by thread: Re: ADO vs DAO How to get the dialog to add/select ODBC DSN Connect in
- Index(es):
Relevant Pages
|
