Hi,
i am using code to hide workbook and show suerform "Kalkulator":
working.
Please Login or Register to view this content.
on form i am using button to bring back workbook with code:
but this is bringing back 2 instances of excel (Excel and Kalkulator.xlsm where my macros and userform is):Please Login or Register to view this content.
Screenshot_12.png
one empty, second one with my macros.
What is causing that?
Please help,
Jacek
Anyone?
Best Wishes,
Jacek Antek
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi Mumps1,
thank you, working but this one:
Application.WindowState = xlMinimized is minimilizing, not hiding whole Excel app like this one:
Application.Visible = False.
So second one is correct (hiding whole Excel) but how to unhide application and go back to my Kalkulator.xlsm.
Best,
Jacek
Last edited by jaryszek; 02-18-2019 at 04:28 AM.
I tried also with:
but this is not working.Please Login or Register to view this content.
Please help,
Jacek
Ok this seems to work:
and in form terminate event:Please Login or Register to view this content.
But this is working great when i have one Excel opened. When i have 2 instances there is a problem because i am hiding all Excel app - this can be annoying when you were calculating something and want to open my excel with form.Please Login or Register to view this content.
Can you help?
How to count instances of Excel and check if i can minimize whole Excel app or only one instance of opened Excel?
Best,
Jacek
Last edited by jaryszek; 02-18-2019 at 05:55 AM.
I am closing topic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks