I want the shared excel workbook to open at the current week not at start of workbook

Hi,

I have a workbook that has tabs for weeks at the bottom and each sheet has the days of the week on it. When it was a stand alone workbook if you saved it , it would open where ou saved it. Now I have shared it, it opens at the first tab, first sheet of the workbook. Is there anyway to override this?

Thanks

Hi there,

Try inserting the following code into the ThisWorkbook VBA CodeModule of your workbook and see if it does what you need:

Please Login or Register  to view this content.

Please note that (for testing purposes) I've added 365 to today's date, because all of the worksheets in the workbook you posted are dated 2020.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi again,

Many thanks for the Reputation increase - much appreciated!

Glad I was able to help.

Best regards,

Greg M