I am looking for a way to capture a click on a standard toolbar tool in Excel with VBA. The primary need is to capture any Copy, Cut, and Paste request by the user. I can capture the hot keys for these functions, but I can't find a way to capture the same functions when the user clicks on the icon on the standard toolbar or when the user uses the menu to select the function.
Here is an undo example from John Walkenbalk http://www.j-walk.com/ss/excel/tips/tip23.htm
I've also used a macro (Called by the worksheet_change event) to force a user to 'paste special.' It should give you a good starting point.