Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to make the VBA code invisible to end user?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to make the VBA code invisible to end user?
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to make the VBA code invisible to end user?
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a trendline invisible? | Excel Programming | |||
make VbA invisible | Excel Programming | |||
How Invisible Can You Make Your Code??? | Excel Programming | |||
Make counter invisible | Excel Programming | |||
Code to make graph invisible / invisisble | Excel Programming |