Forcing a workbook to open on a certain page

[learningguru1978]

Hello everyone. I am creating workbooks that will have to be opened and
completed by a large number of people. The workbooks contain multiple
sheets. I would like the workbook to always open up on the first worksheet.

I understand that if I save it on the first sheet it will open on that sheet
when the person opens it. However, if they save it on a different sheet or
if they send it to someone else when they've saved it on a different sheet I
would like it to always open to the first one. Thanks in advance

 

[FSt1]

hi
put this in the this workbook module.
Private Sub Workbook_Open()
Sheets("yoursheet").Activate
End Sub

 

[learningguru1978]

Thank you FSt1. I'm sorry, but I am not sure what you mean by workbook
module. Can you please explain?

 

[learningguru1978]

Thanks FSt1. I am not sure what you mean by workbook module. Can you
explain that please?

 

[FSt1]

hi
sorry.
press alt+F11. this will bring up the vb editor.
in the project window(far left), expand your project(file).
read down the tree and double click "thisworkbook"
in the code window(big white widow mid far right),chick the left drop down.
it should say (general). from the selection, choose "workbook"
this code should default it
Private Sub Workbook_Open()

End Sub
paste the single line of code i posted.
sheets("yoursheet").activate
substitute "yoursheet" for the sheet name you wish the file to open to.

done. save and close. open to test.
regards
FSt1

 

[learningguru1978]

I got it to work! Thank you so much!!!

hi
sorry.
press alt+F11. this will bring up the vb editor.
in the project window(far left), expand your project(file).
read down the tree and double click "thisworkbook"
in the code window(big white widow mid far right),chick the left drop down.
it should say (general). from the selection, choose "workbook"
this code should default it
Private Sub Workbook_Open()

End Sub
paste the single line of code i posted.
sheets("yoursheet").activate
substitute "yoursheet" for the sheet name you wish the file to open to.

done. save and close. open to test.
regards
FSt1

 

[FSt1]

you are welcome.
regards
FSt1

I got it to work! Thank you so much!!!