Opening on last saved position

[helpme10]

In Excel 2016, opening a file takes you to the cell that was selected when the file was last saved. And actually I think the cell position is saved separately for each individual worksheet. This is acceptable behavior in most cases, except when emailing a large file (with many worksheets) to a client who we want to impress.

The more detail-oriented employees can be relied upon to go through all their sheets and select A1 before saving and sending the file, but in a large organization sending many files there's bound to occasionally be a confused client who opens a workbook to one of the helper tabs or in the middle of a mappings/lookup table and wonder what they've stumbled upon.

Does anyone have a good method or workaround for this?
Note: custom views are disabled because each workbook has tables.

 

[JoeMo]

If you're open to using VBA, you could use a workbook_beforeclose event module to select A1 on each sheet and then activate the sheet you want the client to open to.

 

[helpme10]

If you're open to using VBA, you could use a workbook_beforeclose event module to select A1 on each sheet and then activate the sheet you want the client to open to.

Thanks JoeMo, that's a good suggestion.