software

I use Microsoft Office Excel 2003. I have a spreadsheet with many tabs.
It's a shared spreadsheet with many people making updates.
Regardless of who last saved it, and what sheet they updated, I would
like the spreadsheet to open on Sheet 1. Is this possible? Right now,
the spreadsheet opens on the last sheet updated.

Thank You!
Maria--
Maria
------------------------------------------------------------------------
Maria's Profile: www.excelforum.com/member.php...oamp;userid=10979
View this thread: www.excelforum.com/showthread...hreadid=528377
(Macro Security for your installation of Excel must be set to medium or
low for the following to work

The following macro will cause Sheet 1 to be displayed every time you
reopen the workbook:

Private Sub Workbook_Open()
Sheets(quot;Sheet1quot;).Activate
End Sub

The code for this macro must be saved as follows:

Select Tools gt; Macros gt; Visual Basic Editor

On the left of the Visual Basic Editor Screen you will see a Project
Window with a listing of objects and modules.

The last item on the list of Objects should be quot;ThisWorkbookquot;

Double-click on quot;ThisWorkbookquot;

A window will open titled xxxx.xls - ThisWorkbook (Code)

From the top left dropdown menu select Workbook
From the right top dropdown menu select Open

The subroutine title: quot;Private Sub Workbook_Open()quot; will appear, along
with End Sub.

Add the line

Sheets(quot;Sheet1quot;).Activate

X - out of VB editor, save your workbook and close it with any sheet
selected. When you re-open the file, it should flip to Sheet1.--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: www.excelforum.com/member.php...oamp;userid=32763
View this thread: www.excelforum.com/showthread...hreadid=528377