+ Reply to Thread
Results 1 to 2 of 2

Open Automatically on a particular Worksheet

  1. #1
    Fedarni
    Guest

    Open Automatically on a particular Worksheet

    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.

  2. #2
    Nick B
    Guest

    RE: Open Automatically on a particular Worksheet

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1