Re: Deploying VBA program
to execute the program on opening, put this code in ThisWorkbook:
VB Code:
Sub Workbook_Open()
Call Macro1 'Can be UserForm1.Show or anything else you want to perform on opening
End Sub
If you want to execute your macro without using VB Editor
In Excel
Tool
Tool->Macro
Tool->Macro->Macro
or Alt F8
a new window will open with all macro available
Re: Deploying VBA program
What type of Office Application is this code written for? If it is Access you can use the Tools ===> Start Up to load a particular form when the db is opened.
Re: Deploying VBA program
Thank you. That subroutine does the job.