Clearing the List Cancel

Undo or canceled feature is very useful for us. Who Microsoft Office users never used that feature? Facilities that have been there since the early 90's is used to cancel an action that has just done, because the action was a mistake.

Access the features are very easy to cancel. Two live click the button on the keyboard combination, ie, [Ctrl] + [Z]. Easy, isn't it?

Some people will remove the list of actions that can not be canceled features used. The goal, so that others can not know what changes he has done on the document. The way most "normal" is to save and close the document. When the document is opened, the automatic cancel feature that can not be used because the list of actions have been erased. This step is clearly effective.

But, you can create a short way for it. How short is made compulsory if you frequently remove action list. You can create a new button that you can clean up the list of actions. Later, to remove all the action you made, simply click this button once. Wrong.

Here's the steps of making button:
1. Run Microsoft Excel through the [Start]> [All Programs]> [Microsoft Office] [Microsoft Office Excel].
2. In the Microsoft Excel program, click [Tools]> [Macro]> [Visual Basic Editor].
3. Now you will be at the programVisual Basic. Click [Insert]> [Module] to add a new module.
4. In the editor window, add the following.

Sub ClearUndo ()
Range ( "A1"). Copy Range ( "A1")
End Sub

5. Then click [Debug]> [Compile VBAProject].
6. Press [Ctrl] + [S] to save the compilation of the results that you create.
7. Close the Microsoft Visual Basic window.
8. When you are brought back to Microsoft Excel, click the [Tools]> [Customize ...].
9. Click on the tab [Commands] and select [macros] section in the "Categories".
10. Drag [Custom Button] on the right side to the toolbar. The key is what you will need to click to clear the action list.
11. Then 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].