Alias void Undo feature clearly useful. Microsoft Office users who had never used this feature? Facilities that have been there since the early 90’s was to cancel an action that had just done, because the action was a mistake.
Accessing this feature is also very easy to cancel. Live push two buttons on the keyboard combination, which is [Ctrl] [Z]. Easy, right?
Some people will remove the feature list of actions that can be used not canceled. The goal, so that others can not know what changes he had done on the document. The most “ordinary” is to save and close the document. When the document is opened again, the automatic cancellation feature can not be used because the list of actions already erased. This step is clearly effective.
But, you can create a short way for it. This brief way must be made if you frequently remove the action list. You can create a new button that can clean up the action list. Later, to remove all the action that you have done, just click this button only once. Beres.
You see these steps making the button:
1. Start Microsoft Excel via the [Start]> [All Programs]> [Microsoft Office]> [Microsoft Office Excel].
2. In Microsoft Excel, click [Tools]> [Macro]> [Visual Basic Editor].
3. Now you’ll be on programVisual Basic. Click [Insert]> [Module] to add a new module.
4. In the editor window, add the following commands.
Sub ClearUndo ()
Range ( “A1″). Copy Range ( “A1″)
End Sub
5. After that, click [Debug]> [Compile VBAProject].
6. Press [Ctrl] [S] to save the compilation you make.
7. Close the Microsoft Visual Basic window.
8. When you are taken back to Microsoft Excel, click the menu [Tools]> [Customize ...].
9. Click the [Commands] and select [Macros] in the “Categories”.
10. Drag [Custom Button] is right next to the toolbar. This button will have you click to clear the action list.
11. After that right click the new button you created earlier and click the [Assign Macro].
12. Select ClearUndo and click [OK].
13. Finish creating the new key by clicking [Close].
