How can open the excel macro, vba Windows not being displayed,
Don't need a visual basic popup Windows

Thank you very much!

CodePudding user response:

Private Sub Workbook_Open () 'to open event for the worksheet triggered when
Application. The Visible=False 'will Excel file bai hidden
UserForm1. Show 'like the form
End Sub

CodePudding user response:

Open macro window, select the Opertions, shortcut keys, the macro is run next time run macros, as long as you open the excel table, and press the shortcut key, you can directly run macros, without the need to open the VBA window,



More Excel/VBA tutorial knowledge acquisition, please pay close attention to auspicious programming public number

CodePudding user response:

Thanks for your reply, has been solved, the reason is the macro module to turn off the automatically generated a code inside,
Application. Goto. Reference:="macro 1"