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?

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