| Create Macro Button in Excel 2007 |
|
|
| Computing - Word Processing |
|
If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.. This article is for Excel 2007. If you are interested for Excel 2003. click here Click 'Office Button' icon found on the menu region
Select 'Excel Options' Select 'Customize' Select 'Macros' from the 'Choose commands from' pop list Select the 'Macro' for which a button is to be created and click 'Add'. The macro is now moved to the right-side region (In the screen print, Format and Refresh are the two macros)
Select the macro and click 'Modify' Optionally change the name of the macro and if required change the image Click 'OK' to complete. Trackback(0)
Comments
(2)
|
| Last Updated on Monday, 22 June 2009 07:28 |
Syndicate
now browsing!
We have 34 guests onlineTraining
| UPK TrainingUPK Developer Training Course Description Overview Understanding Developer menu and toolbar itemsSetting Developer PreferencesManaging FoldersManaging DocumentsCreating Views + Full Article |
| More on Training |
Main Menu
Featured
| Creating a Custom Sharepoint ListApart from the default lists that Sharepoint provides, one can also create custom lists. These lists have one default column, 'Title' and additional columns can be created as required. Workflows can... + Full Article |
| More Featured Articles |




Thanks