Hi All:
Please consider the following code:
The above code is in the thisworkbook module.
I'm opening a workbook from a shortcut. It does some processing and then closes itself.
What I'm trying to do is to leave things as they were before execution. So if excel was already open, I want to leave it that way. The problem is that after the above runs, the excel that was running is invisible, so that when the user clicks the Excel icon, she gets a message "'personal.xlsb' is locked", which means that the system is bringing up a new instance of Excel.
I also want to ensure that if excel was running in a visible window in part of the screen, that it stays that way after execution.
Can you help me?
Thanks,
Yossi
Bookmarks