Make Excel Office 365 open at cell A1? Or create a hyperlink to it?

brccoll 

Found a possible answer to your question, here:

https://www.techrepublic.com/blog/microsoft-office/automatically-save-excel-data-or-not-when-exiting-a-workbook/

Rather than forcing sheets to open on A1 in the first sheet, it forces all workbooks to select A1 on the first sheet, save it and then close it.

This site suggests a bit of VBA code to be inserted in "ThisWorkbook module". I added the part where it selects A1 on the first sheet myself :))

Private Sub Workbook_BeforeClose(Cancel As Boolean)

  Worksheets(1).Activate

  Range("A1").Select

  Me.Save

End Sub

Tried it myself and it works (see attached). Don't know if it works for shared workbooks (couldn't test it) and haven't figured out how to do this automatically for each new workbook. Unless someone else does, you can insert the code in every new workbook you intend to share (if that works, of course) and save it as an "xlsm" file type.