+ Reply to Thread
Results 1 to 3 of 3

Issue with VBE Tools ..Options .. Editor Format

  1. #1
    Registered User
    Join Date
    12-31-2019
    Location
    Inverness, Scotland
    MS-Off Ver
    Office 365
    Posts
    4

    Issue with VBE Tools ..Options .. Editor Format

    I have difficulty reading the vba code on my new laptop so I tried to change to a clearer font. It caused the laptop to close the Excel file. I worked out that it was probably because the font I first selected was unsuitable. It did not have "Western" at the end of the name. Now as soon as I click the Editor Format tab the Excel file immediately shuts down. This happens with any Excel file I try to open.

    Is this a MS 365 reinstall to fix, or has anyone got another suggestion please?

    Thanks, John

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Issue with VBE Tools ..Options .. Editor Format

    I don't have 365, but...
    Regedit:
    Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\VBA\7.1\Common
    FontFace:Courier New

    7.1 is win10...
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-31-2019
    Location
    Inverness, Scotland
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Issue with VBE Tools ..Options .. Editor Format

    Many thanks ProtonLeah. Not very confident changing the registry but I am in there and found the setting. However not sure how to make the change to the new font and don't want to poke about not knowing what I am doing. Can you advise which menu option to use please.
    Many thanks again,
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how delete references in VBA editor, tools
    By PaulLag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-12-2019, 12:54 PM
  2. function(UDF) - VBA EDITOR : Tools > References
    By jagadeesh.rt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-06-2014, 04:57 AM
  3. Tools-->Options on a Mac
    By excel help in forum Excel General
    Replies: 3
    Last Post: 08-13-2009, 11:45 AM
  4. Problem with Tools>Options...
    By PhilG in forum Excel General
    Replies: 1
    Last Post: 11-13-2006, 09:57 AM
  5. [SOLVED] Working with options from within Tools Options clears the Clipboar
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2005, 12:55 PM
  6. [SOLVED] options under tools dose not come up
    By Tracy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2005, 04:33 PM
  7. How to diasble the 'Tools - Options - View - Comments' options?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-19-2005, 07:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1