VishalkumarT
09-20-2007, 03:49 AM
Dear Friends
I got some incredible help from this forum regarding Excel pgming, and my knowledge and interest in prgming has increased due to the same.
So thank you very much.
After playing with GUI components, I need to know If i have placed 2-3 buttons in a controlbar, which enable different macros assigned to them respectively, then how can I edit the images of this buttons ? I mean I tried to go to "Customize" with right-click on any button, then to Macro-buttons and then to edit their image, but once i edit it, after closing the worksheet and reopening it, buttons come with the same images, not with the edited.
I have placed the buttons with following code,
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950, Before:=1
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950, Before:=2
Now I want these three buttons with different images.
hope I have explained the querry correctly.
Thanks in advance
Vt
I got some incredible help from this forum regarding Excel pgming, and my knowledge and interest in prgming has increased due to the same.
So thank you very much.
After playing with GUI components, I need to know If i have placed 2-3 buttons in a controlbar, which enable different macros assigned to them respectively, then how can I edit the images of this buttons ? I mean I tried to go to "Customize" with right-click on any button, then to Macro-buttons and then to edit their image, but once i edit it, after closing the worksheet and reopening it, buttons come with the same images, not with the edited.
I have placed the buttons with following code,
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950, Before:=1
Application.CommandBars("MyCtrlBar").Controls.Add Type:=msoControlButton, ID:=2950, Before:=2
Now I want these three buttons with different images.
hope I have explained the querry correctly.
Thanks in advance
Vt