Activitate sheet 1 and make all sheets read-only
 

To make the file read on:

FileSaveAsClick on ToolsGeneral OptionsEnter a password in the password
to modify field.

To open to the Intro sheet:

Alt+F11 ' to open Visual Basic

In the VBAProject widow: double click on ThisWorkbook and enter this code in
the
code section:

Private Sub Workbook_Open()
Sheets("Introduction").Select
Range("A1").Select
End Sub


This assume that your sheet1 is named Introduction.

Then save the file and close the VB editor.

HTH

"June" wrote:

My spreadsheet has numerous sheets within it. To make things easier for the
user I want the spreadsheet to open to the Introduction sheet. (From there
they can use hyperlinks to go to the desired sheet(s).) What is the easiest
way to do this? Also, how do I make the entire spreadsheet read-only except
for me?

This is my first with Excel to get it to do something for me other than
multiply so could you put it in steps?

Thank you for your help.

June

Activitate sheet 1 and make all sheets read-only
 

Thanks for the fast help!!! It works great!!!!

June



"David Hepner" wrote:

To make the file read on:

FileSaveAsClick on ToolsGeneral OptionsEnter a password in the password
to modify field.

To open to the Intro sheet:

Alt+F11 ' to open Visual Basic

In the VBAProject widow: double click on ThisWorkbook and enter this code in
the
code section:

Private Sub Workbook_Open()
Sheets("Introduction").Select
Range("A1").Select
End Sub


This assume that your sheet1 is named Introduction.

Then save the file and close the VB editor.

HTH

"June" wrote:

My spreadsheet has numerous sheets within it. To make things easier for the
user I want the spreadsheet to open to the Introduction sheet. (From there
they can use hyperlinks to go to the desired sheet(s).) What is the easiest
way to do this? Also, how do I make the entire spreadsheet read-only except
for me?

This is my first with Excel to get it to do something for me other than
multiply so could you put it in steps?

Thank you for your help.

June