+ Reply to Thread
Results 1 to 9 of 9

Font Compatability with Multiple PCs

  1. #1
    Registered User
    Join Date
    10-19-2017
    Location
    Houston, TX, USA
    MS-Off Ver
    2016
    Posts
    9

    Font Compatability with Multiple PCs

    Hello all,

    I created a Userform in Excel 2016 that incorporates a font that is not available by default on PCs.

    I installed the (.otf) file on my PC. When I transfer the excel workbook to load the Userform on another PC, the default font (Arial) is used.

    Is it possible to incorporate some code in VBA to check whether the font is available and install it if it isn't?

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,272

    Re: Font Compatability with Multiple PCs

    There probably is a way, but is the font in question licensed for multiple PCs/users? Which font is it and where did you get it from?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    10-19-2017
    Location
    Houston, TX, USA
    MS-Off Ver
    2016
    Posts
    9

    Re: Font Compatability with Multiple PCs

    Ali,

    The font is readily available online for free so licensing for multiple users should not be a problem. It is called (Nobel).

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Font Compatability with Multiple PCs

    Installing a font often requires admin privileges - will the users all have that?

    It seems like a lot of effort just for a font to me.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Font Compatability with Multiple PCs

    As mentioned, you likely could. The question is should you?

    MS Office does what is called "font substitution" when a font is used that isnt on the computer. In other words it uses a widely used font like arial in place of the original font. If the original font is present it displays it as expected.

    The problem with using a "custom" font is that there could be many variations of it with the same name. So unless you have a way to acquire the exact same font for everyone, you are most likely sticking to a widely used font. If everyone doesnt have the exact same font then it likely wont work for them anyway.

    Also, its typically a bad idea to have code like this run an installation. It could freak out the user (whom unless the code warns them it will happen will likely be surprised), it could run into issues requiring an admin account to install (and potentially fail which could in turn make your code fail), it could turn out that the source of the font isnt available (at all or to that user) or it could turn out that the source of the font or the font itself becomes compromised in which case you end up helping to spread malware (which at many companies would be grounds to get fired). There are many reasons not to do this and really no good reason to make the effort to do it. The only good reason I could think of is needing to use a company wide font, in which case everyone should have it installed anyway.

    I would advise you reconsider the font you are using
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  6. #6
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,673

    Re: Font Compatability with Multiple PCs

    Taking the opposite approach, is it really necessary? Why not use a standard font?

    Some people get very tetchy about applications that modify their computers. One of them is typing on my keyboard right now.
    Entia non sunt multiplicanda sine necessitate

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,272

    Re: Font Compatability with Multiple PCs

    I don't think you are right about it being free, as I can find lots of licensing information online. Beware sites that seem to be giving fonts away - a lot of them are in breach of copyright. Just wanted to mention it, because it's a really easy trap to fall into.

  8. #8
    Registered User
    Join Date
    10-19-2017
    Location
    Houston, TX, USA
    MS-Off Ver
    2016
    Posts
    9

    Re: Font Compatability with Multiple PCs

    All,

    Thanks for the advice. It seems that the best thing to do is ease my mind and use a common font like Arial or Times New Roman. I am not sure if everyone will have administrative rights so that will be an issue as well as installing without informing the user.

    Regards,

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 11 64-bit)
    Posts
    53,272

    Re: Font Compatability with Multiple PCs

    Very wise.

+ 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. [SOLVED] Formula compatability
    By Miles6978 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2015, 01:28 PM
  2. Help with Format and Compatability
    By KG18 in forum Excel General
    Replies: 0
    Last Post: 07-16-2014, 08:33 AM
  3. [SOLVED] 32 bit and 64 bit compatability
    By manofcheese in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-09-2014, 07:09 PM
  4. Changing cell font colour with VBA....excel 2007 to 2010 compatability issue?
    By qaliq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 07:08 AM
  5. Excel 2007 : Compatability Issue
    By bilalbajwa in forum Excel General
    Replies: 18
    Last Post: 05-20-2009, 08:24 PM
  6. VB backwards compatability
    By mike in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-10-2005, 11:05 AM
  7. PIA compatability
    By Irfan in forum Excel General
    Replies: 1
    Last Post: 07-15-2005, 12:05 PM

Tags for this Thread

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