Posted 8 September 2017, 1:17 pm ESTMy company is using Winforms v. 2.5.2008. I need to know which sheet has focus, especially when there's a hierarchical sheet. Is there some way to do that?
Posted by: tthogan3 on 8 September 2017, 1:17 pm EST
Replied 8 September 2017, 1:17 pm ESTYou should be able to use the ActiveSheetIndex to return which sheet is active and has focus.
Replied 8 September 2017, 1:17 pm ESTWhat if a hierarchical sheet has focus?
Replied 8 September 2017, 1:17 pm EST
You can use the GetActgiveWorkBook method to get the active SpreadView object and then query it's Sheets(0) property to get the SheetView object in that SpreadView.
Replied 8 September 2017, 1:17 pm ESTThat worked. Thanks, Scott.