button to clear selections

[#1]

how do i create a button to clear selections on a sheet?

[#2 · Accepted solution]

hi,

you can build a macro and then activate it with a button:

sub clear

ActiveDocument.ClearAll

end sub

[agsearle]

Right mouse, add new sheet, then select 'button'.

Under Function, select shortcut.

Go to the shortcut tab, and in the drop down function menu, select 'clear all selections....'. There are two depending in which one you want.

Click OK and there you have it. Simples...