Viewing 7 posts - 1 through 7 (of 7 total)
  • Can anyone help me with an Excel problem?
  • thorpedo
    Full Member

    Can anyone help me with the following problem?

    I have an Excel spreadsheet to which a new worksheet is added each week. The new worksheet is named as the week number (i.e. “47” for this week). Does anyone know how I can make it open on the current worksheet regardless of which worksheet was open when it was last saved? I think it can be done with some vba code but I do not have the skills. Thanks.

    mikewsmith
    Free Member

    in VBA select the last worksheet then save as then it will open at that.

    (probably a bad method)

    thorpedo
    Full Member

    Thanks but I really need it to be seamless – I should have mentioned that there are a number of different users of the file.

    PlopNofear
    Free Member

    Stick that in “ThisWorkbook”.

    Basically counts your sheets. Then opens the sheet which equals the count. Stick a minus and a number behind Sheets.Count if you have extra sheets.

    ———————————

    Private Sub Workbook_Open()

    i = Sheets.Count

    Worksheets(i).Activate

    End Sub

    mikewsmith
    Free Member

    Thanks but I really need it to be seamless

    Then users who can’t check what sheet they are on should not have access.

    thorpedo
    Full Member

    PlopNofear thanks, that works fine!

    MWS I agree with you but unfortunately they need to have access

    mikewsmith
    Free Member

    That is what controlled data entry is for, eg via a web page into a database
    The consultant coming out in me, fixing the problem not the symptom

Viewing 7 posts - 1 through 7 (of 7 total)

The topic ‘Can anyone help me with an Excel problem?’ is closed to new replies.