ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   face id / create new icon (https://www.excelbanter.com/excel-programming/335992-face-id-create-new-icon.html)

labrev

face id / create new icon
 
Hi all,
I have downloaded various Face Id Add-ins, to check what icons Face Ids are.
Is it possible to create new or edit icons and paste these into the blank
spaces where no icons are present ?

Many thanks for any help/suggestions

Norman Jones

face id / create new icon
 
Hi Labrev,

First add a default button to a toolbar:

View | Toolbars | Customize | Categories | scroll to Macros | drag the
smiley button in the Commands window to the tool bar of your choice | Close

To edit the icon:
Right-click the icon | right-click the icon again | Edit Button Image | Use
the opened button editor to effect changes | OK | Close

To copy an existing grahic or icon image:
Copy the graphic | Right-click the icon | right-click the icon again | Paste
Button Image | Close.

To use a selection of alternative button icons:
Right-click the icon | right-click the icon again | Change Button Image |
Select an icon | Close.

The bult-in button editor is very rudimentary: you could perform a Google
search for icon editors or icons.


---
Regards,
Norman



"labrev" wrote in message
...
Hi all,
I have downloaded various Face Id Add-ins, to check what icons Face Ids
are.
Is it possible to create new or edit icons and paste these into the blank
spaces where no icons are present ?

Many thanks for any help/suggestions




labrev

face id / create new icon
 


"Norman Jones" wrote:

Hi Labrev,

First add a default button to a toolbar:

View | Toolbars | Customize | Categories | scroll to Macros | drag the
smiley button in the Commands window to the tool bar of your choice | Close

To edit the icon:
Right-click the icon | right-click the icon again | Edit Button Image | Use
the opened button editor to effect changes | OK | Close

To copy an existing grahic or icon image:
Copy the graphic | Right-click the icon | right-click the icon again | Paste
Button Image | Close.

To use a selection of alternative button icons:
Right-click the icon | right-click the icon again | Change Button Image |
Select an icon | Close.

The bult-in button editor is very rudimentary: you could perform a Google
search for icon editors or icons.


---
Regards,
Norman



"labrev" wrote in message
...
Hi all,
I have downloaded various Face Id Add-ins, to check what icons Face Ids
are.
Is it possible to create new or edit icons and paste these into the blank
spaces where no icons are present ?

Many thanks for any help/suggestions



Thanks Norman,

got all that sorted, my problem ( should have given more info on initial
question) is that when I open the file, a new Custom toolbar is displayed and
the Worksheet menu bar is removed.This new CB works fine but I want to tart
it up with some new icons.
here is some code

Sub CreateMenu()
Dim cb As CommandBar, cbMenu As CommandBarControl, cbSubMenu As
CommandBarControl
DeleteCommandBar ' delete the custom menu if it already exists
' create a new menu bar to replace the built-in menu bar
Set cb = Application.CommandBars.Add("MyCommandBarName", msoBarTop,
True, True)
' create a new menu on an existing commandbar (the next 6 lines)
Set cbMenu = cb.Controls.Add(msoControlPopup, , , , True)
With cbMenu
.Caption = "&football"
.Tag = "MyTag"
.BeginGroup = False
End With

' add menuitem to menu
With cbMenu.Controls.Add(msoControlButton, 1, , , True)
.Caption = "&Leagues"
.OnAction = ThisWorkbook.Name & "!Macroname"
.Style = msoButtonIconAndCaption
.FaceId = ?

when I edit/create icon, it always goes back to its original state when the
new CB is loaded.
Hope this helps my cause

Again many thanks


Bob Phillips[_7_]

face id / create new icon
 
You can create icons and load them into a worksheet and paste them into your
new toolbars.
In essence, you need to have the icons as an image somewhere and load the
shape. I do this by putting them on a hidden sheet on the workbook that the
commandbar is created from, with code somewhat like

cbTable.Shapes(shapename).Copy*Picture
cbCtl.PasteFace


where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.


If you want to use the builtin faceids, you would use something like


cbCtl.FaceId = faceIdNum


--
HTH

Bob Phillips

"labrev" wrote in message
...


"Norman Jones" wrote:

Hi Labrev,

First add a default button to a toolbar:

View | Toolbars | Customize | Categories | scroll to Macros | drag the
smiley button in the Commands window to the tool bar of your choice |

Close

To edit the icon:
Right-click the icon | right-click the icon again | Edit Button Image |

Use
the opened button editor to effect changes | OK | Close

To copy an existing grahic or icon image:
Copy the graphic | Right-click the icon | right-click the icon again |

Paste
Button Image | Close.

To use a selection of alternative button icons:
Right-click the icon | right-click the icon again | Change Button Image

|
Select an icon | Close.

The bult-in button editor is very rudimentary: you could perform a

Google
search for icon editors or icons.


---
Regards,
Norman



"labrev" wrote in message
...
Hi all,
I have downloaded various Face Id Add-ins, to check what icons Face

Ids
are.
Is it possible to create new or edit icons and paste these into the

blank
spaces where no icons are present ?

Many thanks for any help/suggestions



Thanks Norman,

got all that sorted, my problem ( should have given more info on initial
question) is that when I open the file, a new Custom toolbar is displayed

and
the Worksheet menu bar is removed.This new CB works fine but I want to

tart
it up with some new icons.
here is some code

Sub CreateMenu()
Dim cb As CommandBar, cbMenu As CommandBarControl, cbSubMenu As
CommandBarControl
DeleteCommandBar ' delete the custom menu if it already exists
' create a new menu bar to replace the built-in menu bar
Set cb = Application.CommandBars.Add("MyCommandBarName", msoBarTop,
True, True)
' create a new menu on an existing commandbar (the next 6 lines)
Set cbMenu = cb.Controls.Add(msoControlPopup, , , , True)
With cbMenu
.Caption = "&football"
.Tag = "MyTag"
.BeginGroup = False
End With

' add menuitem to menu
With cbMenu.Controls.Add(msoControlButton, 1, , , True)
.Caption = "&Leagues"
.OnAction = ThisWorkbook.Name & "!Macroname"
.Style = msoButtonIconAndCaption
.FaceId = ?

when I edit/create icon, it always goes back to its original state when

the
new CB is loaded.
Hope this helps my cause

Again many thanks




labrev

face id / create new icon
 
Bob,
Thanks for your help, having a go at it that later.
If I can't get my head round it , I'll just not put icons in :)



"Bob Phillips" wrote:

You can create icons and load them into a worksheet and paste them into your
new toolbars.
In essence, you need to have the icons as an image somewhere and load the
shape. I do this by putting them on a hidden sheet on the workbook that the
commandbar is created from, with code somewhat like

cbTable.Shapes(shapename).CopyÂ*Picture
cbCtl.PasteFace


where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.


If you want to use the builtin faceids, you would use something like


cbCtl.FaceId = faceIdNum


--
HTH

Bob Phillips

"labrev" wrote in message
...


"Norman Jones" wrote:

Hi Labrev,

First add a default button to a toolbar:

View | Toolbars | Customize | Categories | scroll to Macros | drag the
smiley button in the Commands window to the tool bar of your choice |

Close

To edit the icon:
Right-click the icon | right-click the icon again | Edit Button Image |

Use
the opened button editor to effect changes | OK | Close

To copy an existing grahic or icon image:
Copy the graphic | Right-click the icon | right-click the icon again |

Paste
Button Image | Close.

To use a selection of alternative button icons:
Right-click the icon | right-click the icon again | Change Button Image

|
Select an icon | Close.

The bult-in button editor is very rudimentary: you could perform a

Google
search for icon editors or icons.


---
Regards,
Norman



"labrev" wrote in message
...
Hi all,
I have downloaded various Face Id Add-ins, to check what icons Face

Ids
are.
Is it possible to create new or edit icons and paste these into the

blank
spaces where no icons are present ?

Many thanks for any help/suggestions


Thanks Norman,

got all that sorted, my problem ( should have given more info on initial
question) is that when I open the file, a new Custom toolbar is displayed

and
the Worksheet menu bar is removed.This new CB works fine but I want to

tart
it up with some new icons.
here is some code

Sub CreateMenu()
Dim cb As CommandBar, cbMenu As CommandBarControl, cbSubMenu As
CommandBarControl
DeleteCommandBar ' delete the custom menu if it already exists
' create a new menu bar to replace the built-in menu bar
Set cb = Application.CommandBars.Add("MyCommandBarName", msoBarTop,
True, True)
' create a new menu on an existing commandbar (the next 6 lines)
Set cbMenu = cb.Controls.Add(msoControlPopup, , , , True)
With cbMenu
.Caption = "&football"
.Tag = "MyTag"
.BeginGroup = False
End With

' add menuitem to menu
With cbMenu.Controls.Add(msoControlButton, 1, , , True)
.Caption = "&Leagues"
.OnAction = ThisWorkbook.Name & "!Macroname"
.Style = msoButtonIconAndCaption
.FaceId = ?

when I edit/create icon, it always goes back to its original state when

the
new CB is loaded.
Hope this helps my cause

Again many thanks






All times are GMT +1. The time now is 07:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com