toolbar button to insert symbol

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Aside from creating a macro, is there a way to create a toolbar button that
will insert a symbol (check mark)
 
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
 
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
 

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

Back
Top