Excel 97

E

EADesktop

How can I change a spreadsheet , so that it opens on sheet 1 every tim
someone goes into it , when working on the spreadsheet, it will ope
the last page that a save was done on.

Thanks
 
D

Don Guillett

Your 1st question. Save at the sheet desired or use an auto_open macro in a
regular module or a workbook_open event in the ThisWorkbook module that uses

sheets("yoursheetname").select
 
G

Gord Dibben

EAD

You can use VBA Workbook_Open code to go to the specific sheet.

Right-click on the Excel Icon at top-left corner of Menu Bar. Select "View
Code. Paste this code in there. Save the file.

Sub WorkBook_Open()
WorkSheets("Sheet1").Activate
End Sub

OR use Workbook_BeforeClose code to set the worksheet as the active sheet upon
closing the workbooK.

Note: with either method the code goes into the ThisWorkbook module, not a
general or worksheet module.

In a general module you would use Sub Auto_Open() or Sub Auto_Close()

Gord Dibben Excel MVP
 
F

Fherrera

Hi, my events work. Just not the

workbook_open, auto_open, or workbook_activate ones that i'm trying t
use to accomplish a task. Other events work just fine though...such a
workbook_beforeclose()

When I open the workbook nothing happens (other than the ordinary).
put some msgbox commands in the workbook_open() but it doesn't ru
them.. Could this be because I have the entire workbook protected (Rea
only). Has anyone experienced this or knows away around it?

Thank
 
F

Fherrera

Hi, my events work. Just not the

workbook_open, auto_open, or workbook_activate ones that i'm trying t
use to accomplish a task. Other events work just fine though...such a
workbook_beforeclose()

When I open the workbook nothing happens (other than the ordinary).
put some msgbox commands in the workbook_open() but it doesn't ru
them.. Could this be because I have the entire workbook protected (Rea
only). Has anyone experienced this or knows away around it?

Thank
 
Top