Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
how to auto start a vba script when my workbook opens
Here is what I have presently Private Sub Workbook_Open() Application.Run ("Auto_Prd_Rep.xls!UserForm1") End Sub and here is the error it gives Runtime error '1004' The Macro 'Auto_Prod_rep.xls!UserForm1' cannot be found where Auto_Prod_rep.xls is the name of the excel workbook- csmikle
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
how to auto start a vba script when my workbook opens
Hi I am new to VBA but someone did a script for me in excel that is activated by the click of a button, I have done some changes to the script and now want the script to run when I open the excel workbook. In the VBA project explorer this script is under Forms called UserForm1. My research...- csmikle
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
