Hello EveryOne!
I have got a Useform. I want on Sheet1 when i click on Userform button to open it ; then excel application should be hide and only userform should be show.
I do not want it on startup.
I have attached Excel worksheet with userform.
Thank you
Regards
z-eighty2
Use ...in the userform Initialize event handler. Make sure you set it visible again in the userform Terminate event handler...
Please Login or Register to view this content.
This is generally a bad idea - any issue and you are left with a hidden instance of Excel that will have to be killed using task manager - if you have other, unsaved, workbooks open in that instance, you will lose the changes.
My opinion is it's safer just to hide the workbook windowAgain, making sure to set it visible in the Terminate event.Please Login or Register to view this content.
Last edited by cytop; 01-31-2014 at 11:15 AM.
Please Login or Register to view this content.
Last edited by patel45; 01-31-2014 at 12:21 PM.
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks