Geek Documentation Logo

Fontheads

Version 1.0


Introduction

  • Purchase : Fontheads
  • Software Name : Fontheads · Distribute Invisible Embedded TTF Fonts in Excel Workbooks
  • Software Version : v 1.0
  • Website : airportal.sellfy.store/

If you have already purchased this Software, let me take a moment to thank you for being a loyal customer
You are entitled to free lifetime updates for ALL future builds

This documentation is to help you understand the Software and to give you a more meaningful insight into what it can do. Please go through the documentation and read it carefully · Basic VBA skills will be required to create the Fonthead

Requirements

You will need the following Excel Version & Prerequisite to use this Software

  1. Excel 2010 onwards (32bit or 64bit)
  2. Word 2010 onwards to read the Fonthead documentation on how to create a Fonthead (also includes VBA Code to be copied into an Excel Project Workbook)
  3. Basic VBA skills will be required to create the Fonthead
  4. Access to the VBOM (a setting in Excel) & Macro's must be enabled
  5. Windows PC · NOT a Mac!

No support is provided for customization or development of this Software






About Fontheads #back to top

Excel has always lacked the ability to use or distribute Files using any other Fonts than the ones already installed on the PC that is opening the Files. For the most part presenting data can be done nicely using Calibri, after all it's all about the numbers right? Well that's true, but sometimes it is nice to use a different Font, one that adds a little something extra to your work, maybe for a heading or Title Text

Fontheads are small Excel (*.xlsm) Files that have a minimum amount of Code in the 'ThisWorkbook' Code Module to Install & Uninstall the Font when the File is opened. There is no lag (Code is executed with a tiny Micro-pause to ensure compliance) upon opening the File and the data for the Font is compressed and stored within 'Sheet1' of the File. The Font can then be accessed via the Drop-down Font Menu on the 'Font' Group of the 'HOME' Tab on the Ribbon and used as normal. When distributing the Workbook, the Font will follow it and be seen by anyone opening the File

Fontheads

Features include:

  • * VBA to Install & Uninstall the Fonts
  • * Use the Font in UserForm Labels, TextBoxes etc.
  • * Full documentation on How to create a Fonthead from scratch

Fonthead is a 'Single' 1 Font per Workbook solution to distribute an embedded Font






Getting Started #back to top

The Zip download File

On the 'Fontheads.zip' File, right-click->Extract Files... to unzip the Files. Open and test all of the examples to see the 7 different Fonts that have been embedded into the separate Workbooks

Fontheads Files

The Fontheads (Readme) File

To install your own Fontheads, please open and use the 'Fontheads (Readme).docx' File that is in the decompressed archive. This File is the Bible and contains full instructions on what to do, including all the VBA Code to get the magic working for you. The document will detail how to create a SINGLE Excel Fonthead File that can be distributed with a Font of your choice. It even gives instructions on where to download the Fonts and the type of Fonts to download for embedding

Fontheads Word Documentation File

Using the Font in a UserForm #back to top

Create a new Font as per the instructions in the 'Fontheads (Readme).docx' File. Then add a TextBox Control and set the Font to the Font that you have embedded - here is the 'Plasma Drip' Font added to a TextBox:

Plasma-Drip-UserForm-Textbox

Once the Font is loaded into Memory, you can use VBA Code to reference the Font as you would with any other Font Name


Freebie Code

Fontheads does everything for you by compressing and embedding a Font into the Workbook so that it is distributable. however, if you have a TTF Font downloaded on your PC that you want to load directly into Memory and use for UserForm Labels or TextBoxes etc. here is the Code that you can add to a UserForm Code Module to use the Font. This will load in a Font saved locally, add the Font as a resource and then use the Font for a TextBox and directly in a Worksheet Cell

Option Explicit

Private Declare Function AddFontResourceEx Lib "gdi32" Alias "AddFontResourceExA" _
                                           (ByVal sFIleName As String, _
                                            ByVal lFlags As Long, _
                                            ByVal lReserved As Long) As Long
Private Const FR_PRIVATE As Long = &H10

' InstallFont, will install a Font as a resource
Public Function InstallFont(pFontPath As String) As Long
    InstallFont = AddFontResourceEx(pFontPath, FR_PRIVATE, 0&)
End Function

' UserForm_Initialize, triggered when the UserForm is displayed
Private Sub UserForm_Initialize()

    ' install the Font
    Dim stdFont As stdFont
    InstallFont "C:\Archive\- a_My Programming\- a_My Excel\IndieFlower.ttf"
    Set stdFont = New stdFont
    With stdFont
        .Name = "Indie Flower"
        .Bold = True
        .Size = 24
    End With

    ' use the Font
    Set TextBox1.Font = stdFont
    TextBox1.Text = "foobar"

    ' use it in a Worksheet, the first 3 characters will be Wingdings
    Range("B5").Font.Name = "Indie Flower"
    Range("B5").Characters(Start:=1, Length:=3).Font.Name = "Wingdings"

End Sub                            

Screen Shots #back to top

This is a Screen Shot of the embedded Font called Plasma Drip

The Font is embedded into the "Sheet1" Code Module and loads when opened. This Worksheet can be distributed with the Font so that anyone receiving the File can view the Plasma Drip Font

Fontheads Plasma Drip Font Image 1000px x 654px

This is a Screen Shot of the embedded Font called Wagnasty

This is a subtle, light Font that will travel with the Workbook when it is Emailed or distributed

Fontheads Wagnasty Font Image 1000px x 654px




There are currently no frequently asked questions about this Software that cannot be answered via this documentation






Support #back to top

Please remember you have purchased very affordable Software and you have not paid for a full-time Software design agency - I am but one man. Occasionally I may help with small tweaks, but these requests will be put on a much lower priority due to their nature. You have not PAID for Support, Support is 100% optional and I provide it for your convenience, so please be patient, polite and respectful

Support (limited) for my Software includes:

* Responding to questions or problems regarding the Software and its features
* Fixing valid (replicated) bugs and reported issues for the VERSION I HAVE WRITTEN

Software support does not include:

* Customization and installation services
* Support for third party software or ANY kind of development whatsoever

Before seeking support, please...

* Make sure your question is a valid Software Issue and not a customization request
* Make sure you have read through the documentation and any related video guides before asking support on how to accomplish a task
* Make sure to double check the Software FAQs or online documentation
* Ensure that you access to the VBOM is allowed and that Macros can run in Excel
* Make sure to provide 'proof of purchase' and state the name / version of the Software that you are having issues with when requesting support by Email or via Facebook

How to get Support

Contact Mark Kubiszyn on the Email address provided when you purchased the Software, including the Order Number
Contact Kubiszyn.co.uk via our Facebook Page - remember to be patient, if there has been an issue with your download, I will always respond within 48 hours and will Email you the File directly if neccessary or via Messanger. For other issues the response time may be considerably longer and I may choose to respond to specific questions only (as is my right), depending on what has been asked

Version History (Changelog) #back to top

You can find the version history in the Code Module for any Macro-enabled Software or read more information below. The latest Version is always shown first


Changelog

01.04.2018 - (Version 1) released