MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel menu buttons as clip art

  Asked By: Marty    Date: Nov 08    Category: MS Office    Views: 2600

Where do I find clip art in the form identical, or nearly identical to Excel
menu buttons?



3 Answers Found

Answer #1    Answered By: Tate Thompson     Answered On: Nov 08

er? On the tool bar? Click the blank area of the tool bar. Click Customise.
Right click a button and click Copy Button Image. Then paste it into your
word doc or whatever.

Answer #2    Answered By: Charlie Evans     Answered On: Nov 08

This macro will create a toolbar with 1000 icons that you can copy and paste
wherever you want to paste them. (Customize the toolbar and then click the
modify to get to the Copy command.) I use the icons in other applications
as well as documentation.

Sub ShowFaceIDs()
Dim NewToolbar As CommandBar
Dim NewButton As CommandBarButton
Dim i As Integer, IDStart As Integer, IDStop As Integer

'Delete existing FaceIds toolbar if it exists
On Error Resume Next
On Error GoTo 0

'Add an empty toolbar
Set NewToolbar = Application.CommandBars.Add _
(Name:="FaceIds", temporary:=True)
NewToolbar.Visible = True

'Change the following values to see different FaceIDs
IDStart = 1
IDStop = 1000

For i = IDStart To IDStop
Set NewButton = NewToolbar.Controls.Add _
(Type:=msoControlButton, Id:=2950)
NewButton.FaceId = i
NewButton.Caption = "FaceID = " & i
Next i
NewToolbar.Width = 600
End Sub

Answer #3    Answered By: Jawna Mohammad     Answered On: Nov 08

I do it all the time! I do it from the ShowFaceID toolbar, too!

Once the toolbar is created, right click on it and select Customize.

Locate the AutoSum picture IN the ShowFaceID toolbar and then right click on
it (While in Customize mode) Then you can click the Copy button image.
Copy Button Image is grayed out if you pick off the Standard toolbar,
because it is a combo box. Now switch over to Word and CTRL+V to paste the
Icon into your Word document.

AutoSum = FaceID 226
Plus Sign = FaceID 374

Didn't find what you were looking for? Find more on Excel menu buttons as clip art Or get search suggestion and latest updates.