1
If I open Excel and then open the VBA window then close it, every time I RDP to my computer, the VBA window is open again, even if I closed it before disconnecting.
The next time I am sat locally to my computer, it is open also, but if I close it, it remains closed until I RDP etc.
Has anyone seen this behaviour before?
neildeadman
Posted 2014-06-02T14:56:47.560
Reputation: 407
1Open it, or run VBA? – Raystafarian – 2014-06-02T15:14:01.807
@Raystafarian I only ever open it to change a function I have written or to write a new one. I have not tried just opening the window and doing nothing but closing it. It doesn't happen unless I first open the VBA window though. – neildeadman – 2014-06-02T15:50:48.383
Is this in every file or just a specific file? – Raystafarian – 2014-06-02T15:51:43.683
I have seen this in 2 files now. – neildeadman – 2014-06-02T15:53:31.187
What about files that don't have any VBA? Does it happen with them? Maybe the code is flawed is what I'm getting at. – Raystafarian – 2014-06-02T15:54:16.610
as in my code? I can't see why that would open the window when I RDP... :/ It doesn't do it to any file without VBA. Maybe you can create a file and add a line and see if it happens for you. I can repeat your steps to see. – neildeadman – 2014-06-02T15:56:05.937
I wonder if, the VBa is creating a handle to something which even though you shut it which the session is remembering... – Dave – 2014-06-05T11:00:54.923