 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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.
in VBA select the last worksheet then save as then it will open at that.
(probably a bad method)
Thanks but I really need it to be seamless - I should have mentioned that there are a number of different users of the file.
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
Thanks but I really need it to be seamless
Then users who can't check what sheet they are on should not have access.
PlopNofear thanks, that works fine!
MWS I agree with you but unfortunately they need to have access
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