On Aug 7, 11:22*am, "Michael Downey - CarBiz, Inc."
wrote:
I have an excel file in 2003 and I don't want the users to see my
username/password code which is in VBA. *It is firing off to a remote
sql server and i don't want them to modify or even see that code.

Is there a way to make them not see that?

thanks,
Mike


From another poster:


Nevermind i found my own answer.

Inside the VBE
Select your workbook's project
tools|VBAProject Properties|Protection tab

Lock it for viewing and give it a memorable password.


Be aware that this password isn't going to stop the really dedicated--
but it
will keep most people out.