Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Disable Visual Basic & Script Editor ?

Nov 7, 2004 11:36PM PST

I teach a computer class in a Federal Prison and the inmates are restricted from any programming technics. So I need to disable their ability to create or edit any macro's. But if I uninstall visual basics I loose Access which totally runs from it. Im looking for a way to allow the macro's that are created to run but restrict the ability to create or modify them.

Thanks in advance for any assistance.

Discussion is locked

- Collapse -
Re: Disable Visual Basic & Script Editor ?
Nov 8, 2004 3:57AM PST

Hello chaingang,
Open Microsoft Visual Basic Editor, go to the Project Explorer, point to your project and right click on it. Choose VBAProject Properties..., click Protection, check Lock Project For Viewing, and type in your password. Try it.

Swisse

- Collapse -
Re: Disable Visual Basic & Script Editor ?
Nov 8, 2004 4:27AM PST

Yes that will work for securing an existing project. I need to lock it so they can't even execute the VBA. I found a complicated way using ORK Tool and creating a policy statement on the network. Im still playing with that as I type this.

Thanks for your help !!!