View Single Post
 
Old 04-24-2019, 12:07 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

See the attached file.
Open it and allow macros, then move to Sheet1 (it was saved with Sheet2 being the active sheet). It will try to scroll the current date to be at the left. This does not change the selected cell, that may be off screen; this behaviour can be changed if you want.


The macro only runs on the file being opened. It could instead/as well, act every time you switch to that sheet; there is commented-out code to do that in Sheet1's code-module. You just have to enable it.
Attached Files
File Type: xlsm msofficeforums42334.xlsm (16.2 KB, 10 views)
Reply With Quote