I'm using 2003. I just checked now, and there is no ControlTipText option. I
thought there would be just like on a UserForm. Sorry.
--
Please rate posts so we know when we have answered your questions. Thanks.


"scattered" wrote:

On Aug 28, 12:12 pm, Orion Cochrane
wrote:
There are no properties for the Form buttons, but if you create a button with
the Control Toolbox and hit F4, you will get properties for it. Double-click
the button, then copy and paste the macro into the CommandButton1_Click
procedure (located in the Sheet object where the button resides). When
copying the macro, copy the commands between the macro name and End Sub.

Does this work in xl2003? I can create tooltips on buttons in
userforms no problem, but when I create embedded buttons via the
control toolbox and look at properties (via right click when button is
selected in design mode - F4 seems to do nothing in this context)
control tooltip isn't one of the options. Are you using xl 2007 ?

-scattered