Customization question: how to put up a single button ontotoolbar which converts to "Symbol" font?

M

Michael Levin

I'm running Excel X on my Mac with Panther (OS X). I'm a scientist and often
need to convert some characters to the Symbol font. In Microsoft Word, I was
able to use the Customize feature to put a button onto the toolbar which
converts the selection to be of Symbolic font. In Excel, I can't seem to do
it. When I do "customize" and hit the "command" tab, I can choose Font,
which says "In the Font box, select a font name" but when I click it, it
doesn't let me type a font name nor gives me a list of the fonts (unlike
Word, which does). It looks like it should, but it doesn't. Is it possible?
How do I do it? Please cc: any info to (e-mail address removed). Thanks in
advance!!
 
D

Dave Peterson

I don't use a Mac, so I'm not sure that this'll work.

But for my WinTel pc, I could create a macro:

Option Explicit
Sub MakeFontSymbol()
Selection.Font.Name = "Symbol"
End Sub

And assign that to a custom icon on a customized toolbar.

Excel will find the file that contains the macro when I click on the icon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top