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

Josh,

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

--
Robin Hammond
www.enhanceddatasystems.com


"Josh Sale" <jsale@tril dot cod> wrote in message
news:%(E-Mail Removed)...
> 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
>
>
>
>