Sounds like you are using controls from the Control Toolbox Toolbar and
think you are using controls from the Forms Toolbar. Use the controls from
the Forms toolbar and you will be able to assign a macro. Controls from
the control toolbox Toolbar use events.
The articles will give some insight in to using Control Toolbox Toolbar
events: (they are for userforms, but using them on worksheets is similar).
http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"
Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97
This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.
Here is an article about using Control Toolbox Toolbar controls on a
worksheet:
http://www.microsoft.com/ExcelDev/Articles/activexl.htm
Using ActiveX Controls on a Microsoft Excel Worksheet
--
Regards,
Tom Ogilvy
--
Regards,
Tom Ogilvy
"OWU Programming" <OWU
wrote in
message ...
Is there a VB command method to execute a macro if the
Assign Macro doesn't show. Or is there something
changed I need to fix.
TIA
Dan Cring