Re: Hide Code
- From: Dave Peterson <petersod@xxxxxxxxxxxxxxxx>
- Date: Thu, 15 Nov 2007 14:36:16 -0600
Open your workbook
Select the project in the VBE
Tools|VBAProject Properties|Protection tab
Give it a memorable password
This will stop most people from viewing your code, but it won't stop anyone
who's really interested.
ps. Don't share your workbook as personal.xls. Give it a nice unique name. If
you use personal.xls, then each of the users will have to decide to use your
version of personal.xls or their own personal.xls (excel can only have one file
open with that name).
acss wrote:
I have code in a personal xls and i would like to keep users from viewing or
editing this code since it will be installed on three computers.Can this be
done?
--
Dave Peterson
.
- Prev by Date: Re: Rename Parent work***.name?
- Next by Date: Re: Printing multiple embedded Word Documents
- Previous by thread: Re: Rename Parent work***.name?
- Next by thread: RE: Deleteing columns starting at a certain row.
- Index(es):