假設你的功能是在sheet1中完成.
按下alt+f11,雙擊左邊縱欄的"thisworkbook",然后將下面代碼復制到右邊的編輯框中.退出.以后每次打開就能實現你說的功能.
private sub workbook_open()
sheets("sheet1").activate
cells(2, 2) = cells(4, 2)
end sub
按下alt+f11,雙擊左邊縱欄的"thisworkbook",然后將下面代碼復制到右邊的編輯框中.退出.以后每次打開就能實現你說的功能.
private sub workbook_open()
sheets("sheet1").activate
cells(2, 2) = cells(4, 2)
end sub