资讯

Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.
Run macros by clicking a button on the quick access toolbar 1] Creating Macros in Excel Launch Microsoft Excel. Ensure you have the Developer tab on the menu bar.
To jump in and create your own macros, click the red record button on the toolbar, then hit F9 to begin recording keystrokes and mouse actions.
Adding a VBA Command Button with its respective code is not a complicated task. It just requires a little knowledge of Excel and the macros. This article will show you how.
"Clicking this button (macro) sets your target as your focus, and starts to sheep them if in range (I usually set them when they're out of range, and hit the button again when they come in range ...