Selecting which sheet loads each time

    :no: This is driving me mad!!:flame:
    I am trying to make an excel file load a workbook on a particular sheet, even if the file is saved on a different sheet, I would like it to load up the next time on a specified sheet. Hope this makes sence, and I hope its possible! PLEASE HELP!!

    I think the only way to do this is to put some code in the Workbook_Open event. With the workbook in question open, Right-mouse click on the Excel icon to the left of the File menu and choose View Code. Then in the drop-down menu where it says (General) select Workbook. By default the Workbook_Open event pops up. Put a line like this in there:


    Sheets("Sheet1").Activate

Participate now!

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

Register Yourself Login