ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My Excel (2002) always opens on March 29 tab - how do I change it? (https://www.excelbanter.com/excel-discussion-misc-queries/86566-my-excel-2002-always-opens-march-29-tab-how-do-i-change.html)

johnss14

My Excel (2002) always opens on March 29 tab - how do I change it?
 
It is a shared workbook which tracks any changes made to it. I have a tab
set up for each workday of the year. After reviewing and approving or
denying new changes i go to the current date - hit save and close it.

When I re-open the workbook - it is back on the March 29th tab again. Is
there anyway to either go to the current date tab or get it to stay on the
same page as the last "save" function?

Thanks for any help, hints or ideas that you can offer.

Sandy

Dave Peterson

My Excel (2002) always opens on March 29 tab - how do I change it?
 
Any chance you have a macro that runs that chooses the starting worksheet?

How about the other users? Could they be saving it with the March 29th
worksheet active?

johnss14 wrote:

It is a shared workbook which tracks any changes made to it. I have a tab
set up for each workday of the year. After reviewing and approving or
denying new changes i go to the current date - hit save and close it.

When I re-open the workbook - it is back on the March 29th tab again. Is
there anyway to either go to the current date tab or get it to stay on the
same page as the last "save" function?

Thanks for any help, hints or ideas that you can offer.

Sandy


--

Dave Peterson


All times are GMT +1. The time now is 04:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com