Add controls to a sheet by using the Forms toolbar
If you want to run an existing macro from a worksheet control, make sure the workbook that contains the macro is open.
1. Open the worksheet you want to add controls to.
2. Make sure the Forms toolbar is displayed.
3. On the Forms toolbar, click the button for the control you want to add.
4. On the worksheet, drag the control to the size you want.
5. If you are adding a button, select the macro you want to run when you click the button in the Macro name box.
If you are adding a control that is not a button, right-click the control, and then click Assign Macro on the shortcut menu.
If the macro does not exist, you can record or write a new macro. Click Record to record a new macro, or click New to open a Visual Basic for Applications module in which you can write the macro.
Note When you add a control to a worksheet, the control is available only when the worksheet is open. If you want to run a macro by using a button regardless of the workbooks that are currently open, you can run the macro from a custom toolbar button.
*********************************************************************************
>From: "Belinda Scot" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: MI-L Simple Excel Question - quite frustrating
>Date: Thu, 18 Sep 2003 11:48:00 +1000
>
>Hi Listers...
>
>I've got a minor problem with excel and I can't seems to find the answer after trying the help menu and the web.
>
>I have a data entry worksheet in my application that I need to erase between uses. However, it has many formulas and I don't want to clear these. How can I clear the values entered by the user without affecting my formulas? I would prefer a 'ERASE DATA' button on the spreadsheet.
>
>Really appreciate any help I can get.. sorry that this is not mapinfo related...
>
>:o) Bel... (QUITE URGENTLY NEEDED!!!)
>
>_________________________________________________________________
>Chat via SMS. Simply send 'CHAT' to 1889918. More info at http://ninemsn.com.au/mobilemania/MoChat.asp?blipid=6800
>
>
>---------------------------------------------------------------------
>List hosting provided by Directions Magazine | www.directionsmag.com |
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>Message number: 8422
>
_________________________________________________________________
Hot chart ringtones and polyphonics. Go to http://ninemsn.com.au/mobilemania/default.asp
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8425
