Remove toggle button "focus" (dotted inner border) using VBA
Hi folks
I have a number of toggle buttons dotted around my spreadsheet - not part of a userform - and every time I click on them the "focus" remains on the button, i.e. a dotted inner border appears. I have to click away from the button (to remove the dotted border) before I can use various menu items which are otherwise greyed out.
It would appear that Excel 2003 does not include the "TakeFocusOnClick" option - which I think is what I need. Is there a way of removing the button focus another way using VBA?
Thanks, Matt
|