excel font size must be between 1 and 409.

I apologize to all others for sounding 'preachy' here. Personally, I think the Word-embedment would be obvious to you and the macro approaches too much work (unless the writer is the creator and owner of the font (yes, that doesn't bother you at all either, does it?) and is proud and possessive of it) so I'd concentrate on examining objects in the file. momma said don't say nothin' if you can't say nothin' nice) is your own, I guess. That said, your morality (and you have demonstrated a singular singlemindedness in question and comments here so. So it clearly ain't right for you to go after it. Whatever: Someone went to a lot of trouble to keep it from you. Could even be someone who has some messed up idea it was OK for HIM to steal it so long as he didn't compound that by distributing it. So, obviously I have an overarching concern here: SOMEONE went to a LOT of trouble to hide this font away from you, the user, presumably trying to keep you from taking it. You can use that trick if you have a font you need now and then, but don't want cluttering your font list. It's just 'there' until a macro pulls it or you restart. Note that the insertion into the system font table is NOT an installation of the font so does NOT trigger installation defenses in Windows (and, I assume a Mac as something gives me the impression you have one of them). So look for macros and examine them for hints to the technique used and source of the font information. Or one can do that pretty cleverly in the file itself so long as hiding the font isn't one's goal. xlsm file and its code loads the font name into the system font table so it is accessible to the working file. So it's the source of the font information for the. In any case, the macro-enabled file can have a Word file embedded in it and that file can have the font embedded. (And who needs to display all those nasty file extensions? Turn that off too.) That one can do all the following work (in a flash) ending with opening the one you are working in so you never really notice a macro-enabled file existed as many people do put things in Trusted directories so such piddling annoyances don't happen.

xlsx variety, can be embedded in another Excel file, this one of the macro-enabled variety. Sure I do.)Īs to embedding in other files, an Excel file, of the. See if there is a Word file, or some similar wrapper for the Excel file, and examine it for embedded fonts. Directly since it is a part of the Word file and with VBA. Sure I do.)Īn Excel file can be embedded within a Word file and the Word file itself can have fonts embedded which the embedded Excel file can then access. So one approach would be to examine the spreadsheet for objects and delve into any found. You can Insert an object using the Create from File tab of the dialogue box which can then be accessed by VBA.

Excel font size must be between 1 and 409.