How do i password protect my VB Code from users

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I would like to do a couple of things to hide / protect information in my
excel file (2k3).

1. How can I password protect my VBA so others cannot see or edit it?
2. I Have a worksheet with a command button that starts a macro but I want
to password protect the sheet. I have unlocked the cells that get the update,
but when I run the macro with protection on it says "You cannto use a macro
on a protected sheet". How can I get around this?

Bruce
 
1. Launch VBE using Alt+F11. Check Tools> VBA Project Properties> Protection>
Check Lock and assign password

2. I am not sure I understood your question...Using code you can unprotect
the sheet and then before End Sub you can protect the sheet again...Does that
help???

If this post helps click Yes
 
Thanks Jacob, have 1. working now and understand your point on 2. and will
work on it.

Bruice
 
Back
Top