| 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 43 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
| Track Changes in Word 2003Track Changes, as the term suggests, is a feature in Microsoft Word that helps keep track of the revisions made to a document. This feature is commonly used when two or more users work on the same... + Full Article |
| More Featured Articles |




Thanks