worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,
I have created some worksheet tab inside my file.
Let say the first worksheet is called Main, followed by worksheet called
two, three, four.

Is it possible to allow users to refer to worksheet Main whenever the file
is opened? As far as i know, whenever differ users open the file and using
diff tab like two, three or four when save it, the next user when open will
see that last previous worksheet. Therefore, i would like all my users to see
Main no matters the last user has saved on which worksheet.

thanks!
 
hi
open the vb editor(Alt+F11)
In the project window(far left) expand your project(file)
double click This Workbook
above the code window(far right) click the drop down that says general and
click this workbook.
with will appear in the code window.
Private Sub Workbook_Open()

End Sub
past this code between private sub and end sub
Sheets("Main").activate
should look like this
Private Sub Workbook_Open()
Sheets("Main").activate
End Sub

close vb editor and save file. then each time the file is opened, regardless
of which sheet was last use, excel will always go to sheet main.

regards
FSt1
 
Thanks!

FSt1 said:
hi
open the vb editor(Alt+F11)
In the project window(far left) expand your project(file)
double click This Workbook
above the code window(far right) click the drop down that says general and
click this workbook.
with will appear in the code window.
Private Sub Workbook_Open()

End Sub
past this code between private sub and end sub
Sheets("Main").activate
should look like this
Private Sub Workbook_Open()
Sheets("Main").activate
End Sub

close vb editor and save file. then each time the file is opened, regardless
of which sheet was last use, excel will always go to sheet main.

regards
FSt1
Click to expand...
 
Back
Top