Step 4: Copy the above code and paste in the code module which have inserted in the above step. Step 5: Now press F5 to execute the code. Please find the below XlWindowState enumeration values and their description in the table. Where XlWindowState represents the state of the window in Excel. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
You must be logged in to post a comment. View Details. Don't know then. Bear in mind that SendKeys mimics use of the keyboard, so the code must run at a time when normal keyboard input is possible. In this case the workbook would be open ready for use. Sometimes the code runs too fast to allow time for things to happen on screen.
Could try this code before or after to delay 1 second. I've tried putting that in and it still doesn't seem to work. I am now using your coding for maximizing rather than the coding i had previously. Does it make any difference that there is a form open when i am trying to maximize the Excel application, as this is the only thing i can think of that could be effecting the procedure? Does it make any difference that there is a form open.
Click to expand You must log in or register to reply here. Similar threads T. Question Opening file from outlook - run time error Replies 7 Views Nov 23, tiredofit. Question Excel automatically closing userforms when application is minimized??? RawlinsCross Aug 28, Excel Questions 2. Replies 11 Views Sep 4, Legacy Question Security warning when running macro in ribbon.
Replies 15 Views Jan 5, Alex Blakenburg. Worksheets 1. Paste wb. Close Application. Improve this question. Community Bot 1 1 1 silver badge. Add a comment. Active Oldest Votes. Range "CC36". Range "CC25". Add windows wb. Improve this answer. Patrick Lepelletier Patrick Lepelletier 1, 2 2 gold badges 16 16 silver badges 22 22 bronze badges.
Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
0コメント