ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to increase size of button's image of custom toolbar of Excel (https://www.excelbanter.com/excel-programming/369608-how-increase-size-buttons-image-custom-toolbar-excel.html)

Padam

how to increase size of button's image of custom toolbar of Excel
 
I have created custom toolbar but image's size in custom toolbar using
msoControlButton is very small and blurred using below code. How I can
increase / decrease size of image as well as brightness of image in custom
toolbar?

It would be great help for me, if you can.

My code:

'========================================

Const cImgCommandBarID As String = "TMC Img Toolbar"

'Image code
Dim cbImgBar As CommandBar
Set cbImgBar = CommandBars.Add(Name:=cImgCommandBarID,
Position:=msoBarTop)
'cbImgBar.context = 1000

Dim cbImage As CommandBarControl
Dim imgTool As Shape
Dim sFileName, ImgSheet
sFileName = ActiveWorkbook.Path & "\Images\ABC.jpg"

Const sNAME = "MyToolFace"
'================
' hide appearance of picture from the user
Application.ScreenUpdating = False
' insert picture from file and copy inserted picture
ActiveSheet.Pictures.Insert(sFileName).CopyPicture Appearance:=xlScreen,
Format:= xlBitmap

Set cbImage = cbImgBar.Controls.Add(Type:=msoControlButton)
With cbImage
'.FaceId = 198
.Caption = "TheMarketsImage"
.Style = msoButtonIcon
.Width = 120
.Height = 100
.PasteFace
End With
' remove the inserted picture
ActiveSheet.Pictures(ActiveSheet.Pictures.Count).D elete
Application.ScreenUpdating = True




All times are GMT +1. The time now is 03:38 PM.

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