假设你的功能是在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