VBA issues for users in Citrix
Results 1 to 2 of 2

Thread: VBA issues for users in Citrix
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Aug 2006
    Location
    Australia
    Posts
    268
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA issues for users in Citrix

    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

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,700
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: VBA issues for users in Citrix

    Hi Catherine
    Have you got the line
    Code:
    Application.displayAlerts=False
    
    
    then the close wb line
    
    then
    
    Application.displayAlerts=True
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •