Defaults for active cell on opening a file


Posted by Geoff Black on July 28, 2001 2:31 PM

When I close an excel file and then reopen it, the 'active' cell will be that which was last used, which may of course be anywhere within the file. Is there any way that I can set a default so that the 'active' cell is always at A1 on the first worksheet when I come to reopen the file?

Hope this makes sense to you experts out there!



Posted by Ivan F Moala on July 28, 2001 7:46 PM

Put into Thisworkbook object
Via Alt F11
Ctrl R
double click Thisworkbook

Private Sub Workbook_Open()
[A1].Activate
End Sub


Ivan