Forcing a workbook to open on a certain page
 

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

Forcing a workbook to open on a certain page
 

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



"learningguru1978" wrote:

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

Forcing a workbook to open on a certain page
 

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

"FSt1" wrote:

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



"learningguru1978" wrote:

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

Forcing a workbook to open on a certain page
 

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

"FSt1" wrote:

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



"learningguru1978" wrote:

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

Forcing a workbook to open on a certain page
 

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" wrote:

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

"FSt1" wrote:

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



"learningguru1978" wrote:

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

Forcing a workbook to open on a certain page
 

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

"FSt1" wrote:

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" wrote:

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

"FSt1" wrote:

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



"learningguru1978" wrote:

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

Forcing a workbook to open on a certain page
 

you are welcome.
regards
FSt1

"learningguru1978" wrote:

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

"FSt1" wrote:

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" wrote:

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

"FSt1" wrote:

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



"learningguru1978" wrote:

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