+ Post New Thread
Results 1 to 6 of 6
Windows 7 Thread, Visual Basic Editor - Office 2010 in Technical; Hi again everyone, I've opened this here rather than the Office forum, as it's a mix of Office 20120 Professional, ...
  1. #1

    Join Date
    Mar 2011
    Location
    UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Visual Basic Editor - Office 2010

    Hi again everyone,

    I've opened this here rather than the Office forum, as it's a mix of Office 20120 Professional, Windows 7 and Group Policy on Server 2008 R2.

    This may sound like a bit of a weird question, but I don't suppose anyone knows a way of disabling Visual Basic Editor in Office 2010? We're having a few issues, and could really do with disabling it if possible.

    As I said above, we're using Office 2010 Professional, Window 7 Professional and Server 2008 R2 if it come down to disabling it via group policy.

    Many Thanks

    GreyFox

  2. #2
    JJanisch's Avatar
    Join Date
    Nov 2011
    Location
    Swindon
    Posts
    159
    Thank Post
    17
    Thanked 16 Times in 16 Posts
    Rep Power
    7
    By the sounds of this post (How to turn off Visual Basic for Applications when deploying Office 2003 or Office XP) you are trying to disable the "Visual Basic for Applications" service. From a quick Google search there doesn't seem to be much information floating around.

  3. #3
    JJanisch's Avatar
    Join Date
    Nov 2011
    Location
    Swindon
    Posts
    159
    Thank Post
    17
    Thanked 16 Times in 16 Posts
    Rep Power
    7
    Although the wiki page could provide more infos!

  4. #4

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    8,941
    Thank Post
    232
    Thanked 1,510 Times in 1,206 Posts
    Rep Power
    328
    I know Macros themselves are disabled by default in Office 2010 and this can be enabled using a GPO (as I've done it).

    As for disabling the Visual Basic Editor itself, the only way that might be possible is to create an admin install of Office 2010 then to Customise the installation of what components you want installed.

  5. #5


    Join Date
    Feb 2007
    Location
    51.405546, -0.510212
    Posts
    8,127
    Thank Post
    203
    Thanked 2,391 Times in 1,771 Posts
    Rep Power
    704
    You could use the method described in this thread to either disable the entire Developer toolbar or specific buttons via their Control IDs (also shown in the screenshot below).

    If you do not already have the Office 2010 ADMX templates, you can download them from here and for details on where to copy them to click here.



    To disable the Visual Basic button in Word for example, enable the 'Disable Commands' GPO, click the Show button and enter 1695 in the command bar ID box.

    Code:
    User Configuation / Administrative Templates / Microsoft Word 2010 / Word Options / Disable Items In User Interface / Custom / Disable Commands
    Before




    After



    You may need to disable the relevant shortcut key(s) too.

  6. #6

    Join Date
    Mar 2011
    Location
    UK
    Posts
    37
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi guys,

    Thank you for the replies. Sorry I've not been around - big office move here.
    Unfortunately Michael, creating a custom install is not really possible at this time, but worth looking in to for future images.
    The other two suggestions sound rather promising. I've just had a look in GPMC. For some reason I can't upload a screenshot, but:

    Computer Configuation / Policies / Administrative Templates / Microsoft Office 2010 / Security Settings / *Disable VBA for Office Applications*

    is there. So we've obviously installed some of the templates. I shall give that a try once we've got our worktops sorted.

    Many Thanks

    GreyFox

SHARE:
+ Post New Thread

Similar Threads

  1. What the differnece (Using Visual BAsic 2010)
    By chrisredfield93 in forum Coding
    Replies: 8
    Last Post: 19th January 2012, 09:39 AM
  2. Unable to deply Visual Basic 2010 Express
    By AnnDroyd in forum Enterprise Software
    Replies: 3
    Last Post: 2nd December 2011, 10:17 AM
  3. Replies: 2
    Last Post: 29th September 2011, 09:10 AM
  4. [MS Office - 2010] Office 2010 Equation Editor Guide
    By flyinghaggis in forum Office Software
    Replies: 0
    Last Post: 27th January 2011, 03:29 PM
  5. visual basic 2005 beta 2 tutorials ?
    By mac_shinobi in forum Coding
    Replies: 4
    Last Post: 14th December 2006, 09:43 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •