Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Adella Garcia   on Sep 18 In MS Office Category.

  
Question Answered By: Adalrich Fischer   on Sep 18

I found that because I placed the code  in a command box, then when I
press the command box to display only level1, it worked as
expected. At this time, I lost the cursor. Then if I want to click
the original level  1, 2 ,3 button provided by Excel in the left side
of the spreadsheet, I need to do it twice: first time to bring
cursor's attention back to spreadsheet, second time to do the normal
fold/unfold job. I sloved this problem by adding something like
--
Cells(currentRow, currentCol).Select
--
at the very end of the code in command box to bring cursor's
attention back. It is OK now.

But, I just wonder must I do this extra step? Shouldn't Excel do
that for us?

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on How to fold/unfold outline's level 1(or any level) in VBA? Or get search suggestion and latest updates.


Tagged: