The resone why Ineed this is we have values streaming. This sheet has things looping in it all time and does not allow anything else to open in it's excel intstance.
I may have a solution.
This code:
Application.DisplayAlerts = False
Application.IgnoreRemoteRequests = True...
Thank You but I guess I did not explain good enough.
Double click on a XLS fil it opens Excel and then opens the file.
Doble click on another XLS file it will open the file in the same instance of excel as the first file. (You can go to windows on the menu bar and select either file.)
I need...
How do i make it the excel defualt that,
every time a user double clicks on an .XLS spreadsheet
it will open in its own instance of execel?
The User can open from Windows explorer or desktop.
Thank you all and this web site,
I got it! The answer for me was to start a loop and do a sendKey "ECS" every x seconds. The loop dose not take any processer time if you delay the loop with the Sleep command. You must Declare The sleep function api.
Private Declare Sub Sleep Lib "kernel32"...
The user is editing a cell but never presses enter. The cursor blinks in the cell and no macros can run.
I tried a loop that dose a sendkeys "esc" every 5 min and that works but the Loop kills the cpu usage.
How can I get excel to get out of edit mode every 5 min or so? Please help.
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.