Is there a way to make the VBA code invisible to end user?

[Michael Downey - CarBiz, Inc.]

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

 

[Michael Downey - CarBiz, Inc.]

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.

 

[G-2008]

Michael

In the left pane, right-click on your project and select <Projectname>
Properties. The Protection tab on the properties window should be what
you're looking for. Users will still be able to pull up the VB editor window
but won't be able to access anything.

- Glen