Disable in-book location saving

[Zaeguzah]

Hi everybody. I need some help on this. Every time I save a workbook, the location where I were last (ex cell Z42) is also saved and upon re-opening it again, it opens the sheet to the last location (Z42). So how could I make the workbook and all its worksheets to open at a defined location. ie. A1 for instance.
Hope I was understood and thanks for your help.

[Richard Schollar]

Hi

Open up the VBE (Alt+F11), double-click on the ThisWorkbook module of your workbook in the top left Windows pane and paste in the following code:

Please Login or Register  to view this content.

Save the workbook down and reopen (you will need to Enable Macros for this to work).

Richard

[royUK]

Try

Please Login or Register  to view this content.

[Zaeguzah]

both of them work but not completely. I still have some sheets that don't go to a1. There are 50 sheets in total. Thanks for your replies.

[Richard Schollar]

Have these two pieces of code in the ThisWorkbook module:

Please Login or Register  to view this content.

Richard

[Zaeguzah]

Thanks Richard. Your second code worked as expected. Thanks to all who replied.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save