[Solved] VBA : Start-up Page, NEED HELP!!

  • You need to use an Event macro. The Workbook_Open event should work for you. Place the following code (modified to open the sheet and cell range that you want displayed) in the code modulle for the ThisWorkbook object.


    Private Sub Workbook_Activate()
    Sheets("Sheet1").Select
    Range("A1").Select
    End Sub

  • Try something like this in the ThisWorkbook module:


    Code
    Private Sub Workbook_Open()
    Sheets("Sheet1").Select
    End Sub

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!