Go to ToolsCustomize and select the Toolbars tab, and check Forms in there,
that is the Forms toolbar.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"AJO" wrote in message
...

I have a quick question about this alternative. You say go to the Forms
toolbar and select Button control. Where exactly is the Forms toolbar?
I can't seem to figure out what you're referring to.

Thanks


Toppers Wrote:
Chris,
Some alternatives to Bob's solutions:

(1) Use a button instead of a cell and call macro e.g.

Sub DisplayForm()
UserForm1.Show
End Sub

Go to FORMS toolbar, select Button control and then "Assign Macro"; in
my
example "DisplayForm"


--
AJO
------------------------------------------------------------------------
AJO's Profile:
http://www.excelforum.com/member.php...o&userid=31286
View this thread: http://www.excelforum.com/showthread...hreadid=503758