worksheets


Posted by rosemary on October 18, 2000 6:10 AM

I have a workbook with worksheets titled by month.
I make entries in a particular month, save these
entries and then close the file.
The next time this workbook is opened, it will not
open to the worksheet last worked on/saved. How
can I get the worksheet I last worked on to open
automatically?????

Posted by Cathie on October 19, 2000 1:11 PM


I'm stumped on that. I did it several times and my last sheet that I'm on always comes up first. And I can't find anything under options. What version are you using?



Posted by Julio on October 19, 2000 5:50 PM

You can do it using VB. Here's how, in the VB Editor
(Press Alt+F11) you introduce this code in the
"ThisWorkbook" module:

Private Sub Workbook_Open()

Sheets("Name-of-Sheet").activate

End sub


That's it! If something's not clear please feel free to ask!

Regards!