Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You could open the Workbook and go to Tools-Options-Visual Basic Editor,
then in the Project Explorer pane on the left side of the screen, double-click on ThisWorkbook and then paste in the following code: Private Sub Workbook_Open() Sheets(1).Select End Sub Of course, everyone would have to either set Macro Security on their computers (Tools-Macro-Security) to Medium and select to Enable the macros when the workbook opens, or set it to Low (not recommended). "Fedarni" wrote: I have a spredsheet that is updated by many. How can I make it so that spreadsheet, no matter which worksheet the last person saved in, always opens on the first worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
How do I open a specific worksheet using windows exp... | Excel Discussion (Misc queries) | |||
How do I get my personal macro worksheet to open whenever I open . | Excel Discussion (Misc queries) |