Remembering/Restoring Window Position on Workbook Close/Open Events with Shared Workbooks

[AidenS]

Hi,

First thanks for considering my problem.

Basically I'm trying to implement an auto-saving feature to occur every minute in a workbook I'm creating.

The following code works perfectly when the workbook is exclusive, (not shared) but once I hit the share workbook button the Window position (or scroll location) reverts to the Window position of the last manual save when the AutoSave sub is run. The code still saves the workbook with all user edits, but the problem is that my co-workers have found the constant Window Position change that occurs every minute with the AutoSave to be quite annoying (which I totally understand).

Here is the code that goes into ThisWorkbook:

Please Login or Register  to view this content.

And here is the code that goes into a standard Mod:

Please Login or Register  to view this content.

Note that the 'Workbooks.Open ActiveWorkbook.FullName' line above will cause the Workbook Open event coded for in ThisWorkBook to run, effectively re-starting the 1 minute timer.

If anyone has any idea why the above code works in an exclusive workbook, but doesn't in a shared workbook, please let me know.

Thanks,
Aiden