I found how to insert Excel Forms.
Now I am thinking is there way to have this form to pop up without first opening Excel?
Is there way of preventing user from going Excel-Tools-Macro-VB Editor-Form??? They need to see Form, select reports from the list, click Run and wait...
I am fairly certain that you must open Excel before you can open an Excel form.
Also, I have seen some discussion about removing items from the standard menus. I can't remember the syntax off-hand, but I do recall that you have to be very careful to restore things "as they were" when the user closes out the workbook. Search this forum and Google for more on this.
I think what you're looking for is a VB application which can be run standalone as an exe rather than an excel based app (which would use VBA) - just depends whether you have the tools and the knowledge.....
Rgds, Geoff
"Three things are certain: Death, taxes and lost data. Guess which has occurred"
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.