What would it need to make the Excel scroll down and display the current time in center?
This is an example of how the sheet looks like and it's going for a whole week fluently.
Is there any way to write a script for that?
Help appreciated
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Time-Scrolling
- Thread starter Samzy86
- Start date
What would it need to make the Excel scroll down and display the current time in center?
This is an example of how the sheet looks like and it's going for a whole week fluently.
Is there any way to write a script for that?
Help appreciated
Excel Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
baitmaster
Well-known Member
- Joined
- Mar 12, 2009
- Messages
- 2,042
Welcome to the board
Please clarify, do you want this to be set up on a screen somewhere, and regularly update so that in effect every half hour the screen scrolls by 1 row? Or just centres on the current time when you open the workbook / select the worksheet?
Please clarify, do you want this to be set up on a screen somewhere, and regularly update so that in effect every half hour the screen scrolls by 1 row? Or just centres on the current time when you open the workbook / select the worksheet?
Upvote
0
Similar threads
- Question
- Question
