Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet
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 "kyoshirou" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet
Thanks!
"FSt1" wrote: 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 "kyoshirou" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Discussion (Misc queries) | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) |