VBA issues for users in Citrix

[cmhoz]

Good Morning Excel Geniuses....

I have some VBA files that work perfectly fine for users runing the files on their laptops, but have strange issues for people using Citrix.

One of these is that I can't get a file to automatically save on closing.

eg: I use wbData.Close True and this makes wbData close and save for users on their laptops as you would expect, but users in Citrix get the 'do you want to save' popup and if they don't press YES, it doesn't save...

Our Citrix environments are pretty well locked down and I've had to create some interesting workarounds for other VBA to get around this.

Does anyone else use VBA in Citrix? Any idea is there is some other way to get the file to save and not propmt the user??

Thanks!
Catherine

 

[Michael M]

Hi Catherine
Have you got the line

Application.displayAlerts=False


then the close wb line

then

Application.displayAlerts=True