Forum Discussion
Solved
Make Excel Office 365 open at cell A1? Or create a hyperlink to it?
Hi,
I'm guessing it's a feature that shared Office 365 Excel workbooks open where someone last clicked a cell but we really need it to open at cell A1 every time.
Is it possible to either
- Force 365 workbooks to open at Sheet1!A1?
- Or create an external hyperlink to Sheet1!A1?
Found a possible answer to your question, here:
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.
Riny_van_EekelenThank you. An ingenious solution! Unfortunately it's really the shared online documents I'm trying to get working sensibly and it looks like VBA code won't run online ?
It also looks like creating an external URL to a cell isn't possible?
The best I've managed to find, is to just freeze the top left cells I need displayed at launch. A fairly ugly solution that still doesn't guarantee the workbook doesn't just randomly load to a different tab.
