如何用VBA制作EXCEL的欢迎界面?

2025-04-19 09:01:39
推荐回答(2个)
回答1:


Sub Auto_Open()
welcome.show
End Sub

welcome是你的欢迎界面

"但好象不行,不知是哪个地方有问题"
--------------------------
要新建一个模块存放上面那个过程,在左边右键添加新模块

回答2:

Private Sub Workbook_Open()
ThisWorkbook.Application.Visible = False
frm1.show
For i = 1 To 100000

DoEvents
Next i
frm1.hide
ThisWorkbook.Application.Visible = True
End Sub

'很难完全隐藏EXCEL的开始启动