Hide Code

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

Guest

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).
 
You must log in or register to reply here.

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

How to code it on macro ? 10
loop thru folder looking for files with date code in name 7
VBA insert column with two workbooks open 1
Where to store VBA code for executing against xls in email? 5
Multiple file extensions causing issues 2
Hiding an item in the taskbar 1
How to code it in macro? 2
Linked pictures to cell dropdown 1

Back
Top