Re: Hide vba editor

Tech-Archive recommends: Fix windows errors by optimizing your registry



Hi

You need to remove the CommandBars and Pop up menu item from VBA.
Search for Google to how to disable and enable the CommandBars.

Best Regards,
Jay

"Bit3m3" <Bit3m3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0053AD3D-261E-4FBC-8CAB-A8D37E9D4125@xxxxxxxxxxxxxxxx
Hi,

I would like to use VBA editor but only for people of the ICT department.
We have some people who do not know vba but are trying to programm in it.
We do not want this...since they are not hired to do this and it takes
them
too much time to create these macro's
so...is it possible to remove vba editor without beeing unable to use
excisting macro's?

Thnx


.



Relevant Pages

  • Re: Add method of the CommandBars collection
    ... Am I missing another reference? ... use the VBA code that follows, you must go in through Tools | References ... while in the VB Editor and ensure that you've added a reference to Microsoft ... The question is how do I do use the Add method of the CommandBars ...
    (microsoft.public.access.modulesdaovba)
  • Re: display settings
    ... Are you talking about the commandbars in the VBE. ... using VBA to hide Excel Menus and commandbars? ... "Mark" wrote in message ...
    (microsoft.public.excel.programming)
  • idtextensibility2 onconnection with mda (without dll)?
    ... We are currently developing a simple Access Add-In using VBA. ... all we need but cannot automatically insert CommandButtons to Commandbars. ... Is there any way to get the idtextensibility2 event "onconnection" working ...
    (microsoft.public.office.developer.vba)
  • CustomizationContext : Confused
    ... I have producing a template, and I want to write some VBA to hide some ... I want these commandbars to be disabled when anybody develops a new ... ' --- END VBA CODE ...
    (microsoft.public.word.vba.general)
  • CommandBars and dropdowns?
    ... Query about CommandBars, basically I a migrating a solution from VBA to VSTO ... I have cross posted as I am looking for an answer from either end VBA or VSTO. ... In Microsoft Word 2003 SP3 the Undo icon has a drop down arrow next to it on ...
    (microsoft.public.word.vba.general)