Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
johnss14
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 07:56 PM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 07:56 PM
excel 2002 opens slowly Wadey023 Excel Discussion (Misc queries) 2 February 16th 05 05:03 PM
Excel 2002 crashes Veena New Users to Excel 0 February 16th 05 10:29 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 03:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"