toolbar button to insert symbol

G

Greg In Atl

Aside from creating a macro, is there a way to create a toolbar button that
will insert a symbol (check mark)
 
C

challa prabhu

Hi,
1. Do one of the following:
• On the View menu, point to Toolbars, and then click Control Toolbox.
The Control Toolbox toolbar appears.
• On The Tools menu, click Customize
a) Click the Toolbars Tab.
b) In the Toolbars list, select the Control Toolbox check box.
The Control Toolbox toolbar appears.
2. Click the Close button in the Control Toolbox toolbar.
3. Click and draw a square in the Excel Sheet
The formula bar displays the following formula:
=EMBED(“Forms.Checkbox.1â€).
4. Right-click the check box button, point to CheckBox object, and then
click Edit.
Now edit the check box field
5. Click the Design Mode button in the Control Toolbox toolbar.
Note: The Design mode button toggles to Exit Design Mode button, after you
select.
6. In the Excel sheet, click the check box to display a tick mark.
7. Click the Exit Design button in the Control Toolbox toolbar

Challa Prabhu
 
G

Greg In Atl

I was thinking more along the lines of using the Symbol option on the Insert
menu to insert a check mark symbol. I've done this succesfully by having a
macro go to the Insert menu, select Symbol, then select a check mark symbol.
This works, I just thought there was an easier way
 
Top