Better looking command buttons on a worksheet

[Josh Sale]

My add-in dynamically creates a number of command buttons that sit on the
worksheet. I use code like:

activeSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", ...)

This is all well and good. However the command buttons that get created are
the old fashioned (Windows 3?) square buttons that just don't look very good
anymore.

Is there a way to get more "modern" command buttons? You know, rounded
corners, etc. The buttons need to be OLEObjects (as opposed to say Form
command buttons) because I need the events raised by OLEObject command
buttons.

TIA,

josh

 

[Robin Hammond]

Josh,

You could create your own pictures, insert them into the sheet, then assign
a macro to the picture.