Hi bearnone,
In Excel, open the Visual Basic Editor (Alt+F11) and click 'View' 'Project Explorer'. From project explorer, you should be able to assign the modules and forms to a particular file/sheet/template, mainly by right-clicking on each object.
Hope this helps,
Assad
Hi John,
You don't need to call the batch file.
Simply use the following :
Sub NetSend()
Shell ("net send recipient message")
End Sub
Regards,
Assad.
Open the Visual Basic Editor (Alt+F11) and write this :
Private Sub Workbook_Open()
UserForm1.Show
End Sub
where UserForm1 is the name of your form. That's it.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.