Go to today's date

[KamranMustafa]

Hello,

I have a spreadsheet that has got 1st 2 rows for heading, 1st column frozen and row 3 has got dates for whole year 2017.

What I want is:

1. When you scroll horizontally, the heading/title should remain frozen and doesn't move.
2. Whenever I open this spreadsheet, it automatically take me to today's date, every time I open it, i have to scroll it which is frustrating and I am sure there must be some simple solution to that.


Many thanks.

[TMS]

Not everyone will open files on file sharing servers so you are better uploading to the forum.

That said, you could use a Workbook Open event handler and, within that, use Application.Match and Application.GoTo to locate the cell with today's date and scroll to it.

[KamranMustafa]

I tried to attach it, the attachment button is not working. It doesn't show anything when I click it, tried with google chrome and firefox, didn't work

[Pete_UK]

The Paperclip icon does not work.

To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[KamranMustafa]

There is it, attached it.

[TMS]

Copy the following code to a standard module:

Please Login or Register  to view this content.

Now add this code to your ThisWorkbook class module:

Please Login or Register  to view this content.

Save, close and re-open the workbook.

[KamranMustafa]

Awesome, that worked! Thanks a million!

Only have one query left now, frozen top title

[TMS]

I have to be honest and say I don't know you're going to do that.

I thought maybe a Text Box, not moving or resizing with cells might have worked but it didn't (at least, what I tried didn't.)

[KamranMustafa]

I have tried placing a text box, I just want a static title when I scroll through dates horizontally, trying to get it done in someway.