Saving a worksheet without excel remembering the last selected cell

Hi there, Thanks in advance for any help provided.

I'm sure there is a simple solution to this simple problem but google has turned up nothing as far as i'm aware.

We are broadcasting a spreadsheet on a large tv screen in the office and are using Microsoft sharepoint and office online to enable people to edit this spreadsheet from their computers. The changes are then reflected on the screen

Just one small problem - Before they click save, the user has to select cell A1 so that, when loaded, the spreadsheet opens and fits the screen.
If they dont select cell A1, the main spreadsheet refreshes (reloads the saved file) and jumps to the last active cell when saved which causes the some parts of the workbook to go off screen.

Is there a way to have excel always save pointing to a specific cell or am I going to have to keep slapping my co-workers over the head if they forget to click A1 before saving.

Many thanks, I look forward to learning a way around this if possible

Take Care,
Dan

Hi Alan,

Thank you for your really fast reply. I see its a basic script to tell it to select A1 prior to closing.

Unfortunately, it hasn't worked. I've set the security settings to always run macros for now but Excel still remembers the last cell selected

I've attached a screenshot of the VBA, hope it helps. Thanks Again

Dan

What file type are you savin it as: .xlsx or .xlsm
a .xlsx file will not keep anything you enter in the vba
a .xlsm file is a macro enabled file which should keep any macro that you and as long as you enable macros it should work.

Hey,

Thanks again. I did get a message from excel saying it needs to be saved in the different format.

It is saved as a .xlsm and, when opened, does have VB code there. cheers

Dan