How to get Spreadsheet to hide and VBA form to load on application load
Posted on 2007-08-08
I need help with an Excel document that I am working on. What I need to do is upon the Excel document loading, hide Excel and display a VBA form. I am relatively new to VBA, so it could be something I am doing wrong or missing.
I have tried the following and similar methods in the actual sheet object, but to no avail...
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.Visible = False
Any help would be greatly appreciated.