topic Re: Can I block visual basic editor? in VBA Forum

Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 15:28:27 GMT

We need to prevent end users from accessing the visual basic editor. Is this possible? We need to prevent people from creating new code.

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 15:49:46 GMT

A simplistic approach would be to UNDEFINE the following commands at startup.

VBAIDE
VBAMAN
VBARUN

What kind of code are they writing? If it can benefit others, I say let them do it.

--
Matt W
[Insert funny quote/saying here]

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 16:12:02 GMT

Would that then prevent them from running approved macros ?

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 16:34:51 GMT

Yep it would....

I don't think you could....
If you don't want them to change/access the code of a certain VBA application, consider protecting it with a password. Now keep in mind that these passwords CAN be cracked, but if they do so, you have a bigger problem on your hand then VBA access.... (hope you know what I mean)

Other than that, I would recommend a simple meeting with your designrs (or the persons that you want to block acces) and set some clear rules.... I don't know any other way to disable it...

Sorry, but I hope this helps.

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 17:14:01 GMT

> Yep it would....
But not if you use (vl-vbarun...

--
Matt W
[Insert funny quote/saying here]

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 18:19:39 GMT

If it is just that you don't want them to change the dvb, i.e. they can see
the code but not edit, then you can place the dvb on a read-only network
folder.

--
----
Ed
----

Re: Can I block visual basic editor?

arcticad — Fri, 07 Jul 2006 18:51:45 GMT

or password protect your .dvb files .....

Re: Can I block visual basic editor?

Anonymous — Fri, 07 Jul 2006 19:19:33 GMT

> We need to prevent end users from accessing the visual basic editor. Is this possible? We need to prevent people from creating
> new code.

But they want to stop users from creating NEW dvbs.

You can always just take AutoCAD away from them. That'll stop 'em! : )

--
Matt W
[Insert funny quote/saying here]

Re: Can I block visual basic editor?

Anonymous — Wed, 12 Jul 2006 15:13:34 GMT

If you have a password protected dvb file in the load up suite then the user cannot use/edit the project, and i don't know of any way to add a blank project to the VBA IDE

Michael

Re: Can I block visual basic editor?

Anonymous — Wed, 12 Jul 2006 21:40:00 GMT

Hi Michael,

If a VBA project is loaded and it contains any SUBs, then they are visible
to the user and he can start them.
If there are no visible subs, then how is any one supposed to invoke the
commands within the DVB?

Unless the user knows the password they will not be able to edit the code.

There is no way the user can be prevented from unloading a project.

Nothing will prevent the user from using VBAMAN New from creating an new
project and doing as they like with it.

Quite frankly, this whole discussion is ludicrous. What can a user do with
VBA that is so deleterious that they should not be allowed to do it, and yet
cannot be done with all the other methods of AutoCAD customisation, or with
Windows Explorer, Regedit, the FORMAT command etc.?

Put this command in a menu:
ERASE;All;;QSAVE;;
Need less to say I have tested this.

--

Laurie Comerford
CADApps
www.cadapps.com.au

wrote in message news:5234402@discussion.autodesk.com...
If you have a password protected dvb file in the load up suite then the
user cannot use/edit the project, and i don't know of any way to add a blank
project to the VBA IDE

Michael

Re: Can I block visual basic editor?

Anonymous — Thu, 13 Jul 2006 07:43:33 GMT

HI Laurie,

Thanks for the tip, I will now go and give it a try. Your right VBA should be available to everyone, thats how i am using it.

Still, you have to admit it is an interesting question.

Michael