RE: ActiveX command button
- From: "Daniel McCollick" <mccollick24@xxxxxxxxxxx>
- Date: Thu, 14 Jul 2005 12:20:04 -0700
Greg,
I would be interested in seeing this.
Thank you
--
Dan McCollick
"Greg Wilson" wrote:
> I developed a utiltiy a while back that allows you to replicate the common 3D
> format options: raised, sunken, bump and etched. This can be applied either
> to worksheet cells or to rectangles.
>
> One use of this is to format a worksheet cell (or cells) to look like a
> command button. The caption can simply be typed into the cell. You have a lot
> more flexability this way. You assign a macro to the 3D format which is in
> fact a grouped shape object.
>
> If you're interested, I can provide the code responsible for the raised 3D
> effect which should solve your problem. I quite using command buttons myself.
>
> Regards,
> Greg
>
> "Dr.Schwartz" wrote:
>
> > I have added a command button manually and sized it quite small. Therefore I
> > want the size of the caption font to be as big as possible.
> >
> > My question is: Can I decrease the command button margin (the space between
> > the button edge and the caption) in some way?
> >
> > The Doctor
.
- Prev by Date: Subroutine vs GOTO "On Error"
- Next by Date: Re: Installation of "Add-Ins" in code
- Previous by thread: Subroutine vs GOTO "On Error"
- Next by thread: range division
- Index(es):
Relevant Pages
|
