VBA code not running for some users

• 11-03-2008 7:33 AM

  mebenz Joined on 10-01-2008 Posts 11	VBA code not running for some users Reply Contact When I log into our citrix server, the VBA code on a window runs.  However, another user logs into the same citrix server and the code does NOT run.  I have even changed the permissions on the dynamics.vba file to be full control for everyone.  Why is this code not running for some users?

• 11-03-2008 3:54 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: VBA code not running for some users Reply Contact This sounds like the registry permissions issue discussed in the following Knowledge Base (KB) Article:   A user who is not an administrator experiences VBA permission problems in Microsoft Dynamics GP https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;929612 David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics Support - Asia Pacific Microsoft Dynamics (formerly Microsoft Business Solutions) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP Any views contained within are my personal views and not necessarily Microsoft policy. This posting is provided "AS IS" with no warranties, and confers no rights.

  Tags: VBA, Permissions

• 11-05-2008 6:35 AM

  In reply to

  luvsql Joined on 09-03-2008 Posts 2	Re: VBA code not running for some users Reply Contact We have been running Dynamics 9 with this vba code on our citrix servers for 2 years and it's never been an issue until recently.  I look at this TK and we have to change registry permissions?  We can't do that in a corporate network.  I tried method 2, but receive an error with the regtlib.exe not existing.

• 11-06-2008 3:10 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: VBA code not running for some users Reply Contact If this is caused by the registry permissions issue (which is common on Citrix/terminal server), then you will need to get the IT guys to make the registrry changes or, make everyone administrators, or stop using VBA. I have had other sites complain about changing the registry, but that is what is required. I cannot say what has changed, maybe these are new Citrix machines and the changes which were made previously have been lost.  David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics Support - Asia Pacific Microsoft Dynamics (formerly Microsoft Business Solutions) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP Any views contained within are my personal views and not necessarily Microsoft policy. This posting is provided "AS IS" with no warranties, and confers no rights.

  Tags: Terminal Server, VBA, Citrix

• 11-07-2008 6:52 AM

  In reply to

  mebenz Joined on 10-01-2008 Posts 11	Re: VBA code not running for some users Reply Contact I went another route. I added a trigger to the SY00500 table and set the Post To GL = true whenever an inventory batch is saved.  Much easier than having to modify registry permissions on each server we have.  I don't know any corporation that would give all users "Full Permission" on registries.  That's just unheard of.

• 11-09-2008 5:05 PM

  In reply to

  David Musgrave [MSFT] Joined on 07-03-2007 Posts 116

  Re: VBA code not running for some users Reply Contact It is full control permission on 4 keys only (as per KB 929612): https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;929612 • HKEY_CLASSES_ROOT\Clsid • HKEY_CLASSES_ROOT\Typelib • HKEY_CLASSES_ROOT\Interface • HKEY_LOCAL_MACHINE\Software\Classes\CLSID It solves the problem and most sites using VBA on Terminal Server/Citrix have made this change.  David Musgrave [MSFT] Escalation Engineer - Microsoft Dynamics GP Microsoft Dynamics Support - Asia Pacific Microsoft Dynamics (formerly Microsoft Business Solutions) http://www.microsoft.com/Dynamics mailto:David.Musgrave@online.microsoft.com http://blogs.msdn.com/DevelopingForDynamicsGP Any views contained within are my personal views and not necessarily Microsoft policy. This posting is provided "AS IS" with no warranties, and confers no rights.

  Tags: VBA, Registry