Version 1.0
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
You will need the following Excel Version & Prerequisite to use this Software
No support is provided for customization or development of this Software
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
Fonthead is a 'Single' 1 Font per Workbook solution to distribute an embedded Font
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
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
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:
Once the Font is loaded into Memory, you can use VBA Code to reference the Font as you would with any other Font Name
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
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
This is a subtle, light Font that will travel with the Workbook when it is Emailed or distributed
There are currently no frequently asked questions about this Software that cannot be answered via this documentation
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
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
01.04.2018 - (Version 1) released