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.
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"
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?
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Command Button
Any advise, help would be greatly appreciated.