-
1 Attachment(s)
Scrolling down flowchart
Hello,
Please can someone help me, I am trying to achieve is for the screen to follow the flowchart. So that each time that I press next, the workbook scrolls down so that I can see the next step/shape without having to manually scroll.
I have attached the document so that you can see what I mean - please can someone help?
Many thanks in advance!
Kate
-
Kate,
I am sorry, but My Excel XP (2002) can't even run your code. Also I did not see any "Next" buttons on any sheet.
At least this post will bump your question to the top of the list again.
-
1 Attachment(s)
See the attached workbook with modified code of Module2.
All modifications are commented with tag "ZVI".
-
Add below lines in your code to scroll down
Code:
ActiveWindow.SmallScroll Down:=15
You can aslo scroll up by using negetive number as shown below
Code:
ActiveWindow.SmallScroll Down:=-15