Web Development

General discussion


Command Button

By fhu ·
I have a command button on the toolbar of my excel spreadsheet. However I need to send this spreadsheet out to other people and once sent to them, the command button doesn't appear on their toolbar. Is there a way of making it happen, or even better is there a way of having the command button in the spreadsheet (I mean in one cell)?
Any advise, help would be greatly appreciated.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by dryflies In reply to Command Button

Open the worksheet where you want to add an ActiveX control.
Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
Click the button for the control you want to add.
On the worksheet, drag the control to the size you want.
If you're adding a check box, text box, command button, option button, list box, combo box, toggle button, or label, enter the text you want to appear on the control.
Set the properties you want for the control: right-click the control, and then click Properties on the shortcut menu.

For information about the properties, press F1 in the Properties dialog box to display the Microsoft Visual Basic Help for Microsoft Forms.

Do one of the following:
Add VB macro code for a control to be used in Excel

Right-click the control, and then click View Code on the shortcut menu.

In the Visual Basic Editor, write your macro code.

For information about writing macro code, see Visual Basic Help.

To quit, click Close and Return to Microsoft Excel on the File menu.

Add a Web script for a control to be used on a Web page

Click the worksheet anywhere within the data that will go on the Web page.

On the Tools menu, point to Macro, and then click Microsoft Script Editor.

In the Script Editor, write your script, using the control ID to handle events for the control.

For information about developing Web scripts, click the option you want on the Help menu in the Script Editor window.

To return to Excel from the Script Editor, click Exit on the File menu.

To quit design mode and enable the ActiveX control, click Exit Design Mode

this is direct from the excel help file "Add a button"

Collapse -

by dryflies In reply to

please rate my answer

Collapse -

by fhu In reply to

Poster rated this answer.

Collapse -

by dryflies In reply to

this is wierd, I got the e-mail saying you rated the answer but when I came back to check, it shows as not rated even though the question says it is closed thge comment and answer buttons are still visible. Would you please try again to rate my answer?


Collapse -

by fhu In reply to Command Button

This question was closed by the author

Related Discussions

Related Forums