View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default After checking control checkbox returning focus to the sheet

After a user has checked a control checkbox, the focus normally remains on
the control. I don't like this. Now to return the focus to the sheet I'm
using:

ActiveWindow.RangeSelection.Select

But this is less than perfect. If the active cell is not in view, the
spreadsheet will jump to put it in view. Is there some other way I can
return the focus to the sheet without this quirk?

Thanks, Don <donwiss at panix.com.