Save file so that next time it's opened Range A1 is active and in the window?

Despite trying these 3 ways to make A1 active before saving the workbook, when I reopen the workbook later it will still be on column J. How can I save it on a certain column? I don't want a workbook open event. If I manually open a workbook and select a1 and then save, it works fine.

'None of these have worked

Range("A1").Select

Range("A1").Activate

Application.Goto Reference:=Sheets(1).Range("A1"), scroll:=True

Originally Posted by dmasters4919

Despite trying these 3 ways to make A1 active before saving the workbook, when I reopen the workbook later it will still be on column J. How can I save it on a certain column? I don't want a workbook open event. If I manually open a workbook and select a1 and then save, it works fine.

'None of these have worked

Range("A1").Select

Range("A1").Activate

Application.Goto Reference:=Sheets(1).Range("A1"), scroll:=True

I just came up with a silly work around but it works. If I add a sheet and then immediately delete it before selecting A1 I don't have this problem

    With Sheets.Add
        .Delete
    End With

Hi,

if a file saved is not reopened at the same window position, check event code !

What do you mean by the event code? I would prefer not to use a workbook_open event. Also unfortunately my workaround I posted yesterday is not working when I implemented it as part of the entire sub, despite working 100% of the time when testing that part only. Very frustrating

Originally Posted by dmasters4919

I would prefer not to use a workbook_open event.

Why?

Simplest solution would be:

workbook_open

range("Sheetname!A1").select

Originally Posted by BellyGas

Why?

Simplest solution would be:

workbook_open

range("Sheetname!A1").select

Because the macro I'm working on is going to open a different workbook every time. I can't use VBA to write more VBA inside the workbook. Even if I could that would seem like a crazy solution

Or you could use the 'before_save' event.....

Ah I see. So....immediately after the workbook.open command can you just put a range("A1").select command?