the following program doesn't work when open workbook. possible reasons?
' select first sheet when workbook opened. private sub workbook_open() sheet4.select sheet4.range("b1").select end sub
if hit alt+f11 go vba code editor. on left side, under file name see different sheets, , whatever modules might have in there. if go under thisworkbook module , place code there, automatically run when start excel file.
Comments
Post a Comment