excel打开自动运行宏的VBA

2025-03-10 22:19:50
推荐回答(1个)
回答1:

如果你想打开vba就自动运行这个代码的话

sub auto_open()
Application.OnTime Now + TimeValue("00:05:00"), "按钮68_Click"
'
' 按钮68_Click 宏
'
'
    ActiveWorkbook.RefreshAll
    ActiveWorkbook.RefreshAll
    ActiveWorkbook.RefreshAll
    ActiveWorkbook.Save
end sub


或者
sub auto_open()
call 按钮68_Click
end sub