Disable VB Editor in Excel 2003?

No call to do this myself so cannot validate the viability but since a response is proving difficult you might like to check http://support.microsoft.com/kb/281954

Chris

How about password protecting the code?

OK if we disable vba, it will not allow macros to run.  Is there a policy or registry setting to figure out only in a certain path, they are allow to run macros, as it would be trusted, otherwise deny running the macros if they running it from a different path location.

Not that I am aware of ... how about signing the approved code ... of course they are at liberty to sign their own code but it would be a bit of a help!

Chris

So, you really need the code to only run when the workbook is in a certain location as well as protect the code from being see/modified?

Correct Aikimark

what are valid locations and what would be examples of invalid locations?

c:\macros  = valid
all other locations invalid :)

How can I make it run when excel launches, cause this is for Remote Desktop users.  Any registry locations, or?

I don't understand.  It is your code that you are protecting.  If you don't want the code to execute, then it seems like you have what you need.  You just need to implement this check in your routines.  If you have a Workbook_Open() event coded, then you would also add the check there.

Sorry I am just wondering where I can put this code, so it occurs on the server, we have multiple customers logging in and I want to make sure the code is there everytime they load up or create a macro.

I would start by packaging your code as an add-in.  That way, the code will be in everyone's Excel environment.