Hiding/Protecting vb code in excel

  • Thread starter Thread starter IanStrange
  • Start date Start date
I

IanStrange

Hi can anyone tell me how to either hide or protect the vb code on a
spread sheet.
Thanks
Ian
 
Ian,

1. Open the workbook that contains the VBA code
2. Activate the Visual Basic Editor by pressing Alt+F11 in Excel.
3. Tools - VBAProject Properties...
4. On the "Protection" tab, check "Lock project for viewing"
and type the same password twice in the textboxes.
5. OK
6. Save the workbook.

The VBA code will not be hidden for you at this point, but if you
switch back to Excel (Alt+F11), close and re-open the workbook,
you will see that the VBA code cannot be seen without providing the
password.

Ture Magnusson
Karlstad, Sweden
 

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

Protect/hide VB code? 2
To protect user's privacy 1
hiding a row 4
Allow comments in protected sheet using VB 4
Prevent User from Changing Password 2
file path or IP address protected 1
Option Private Module (for Object Modules) 5
Protection occurring automatically after first cell entry 1

Back
Top