Reply to thread

Message: [QUOTE="FSt1, post: 3185778"] hi sorry. press alt+F11. this will bring up the vb editor. in the project window(far left), expand your project(file). read down the tree and double click "thisworkbook" in the code window(big white widow mid far right),chick the left drop down. it should say (general). from the selection, choose "workbook" this code should default it Private Sub Workbook_Open() End Sub paste the single line of code i posted. sheets("yoursheet").activate substitute "yoursheet" for the sheet name you wish the file to open to. done. save and close. open to test. regards FSt1 [/QUOTE]