How do i password protect my VB Code from users

[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

 

[Jacob Skaria]

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

 

[Bruce]

Thanks Jacob, have 1. working now and understand your point on 2. and will
work on it.

Bruice