View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 141
Default Minimizing application from VBA



I've created an application in Excel VBA.
I would like to have Auto_Open(), plus a module if required, minimize the application while leaving the userform open. This essentially hides most evidence that the application in running in Excel VBA. I've tried about a dozen different combinations of code, but haven't yet succeded.

If I do application.windowsize = xlminimize followed by userform.show the form shows in
the minimized application leaving a flashing icon on the application bar.

Ideas would be appreciated.