How do you add a symbol to the toolbar?

[HuntnPeck]

I'd like to add a formattable checkmark to the toolbar in Excel 2007. My desire is to select it when needed and simply insert it into any cell. Is this difficult to do?

[arthurbr]

Hi,
maybe posting in the 2007 forum will yield help faster?

[Andy Pope]

What exactly do you mean by formattable checkmark?

Are you refering to the checkbox control?

[shg]

How about instead a simple macro that inserts a checkmark into the active cell? You could assign a shortcut like Ctrl+Shift+K:

Please Login or Register  to view this content.

[davesexcel]

A RightClick worksheet function could work as well
Paste this code in the Worksheet module, right click on the sheet Tab and select view code, paste the code there
Right click on Column B to get a check mark, right click on column B that has a check mark to clear the check mark.

Please Login or Register  to view this content.