25 August, 2010

Using GP Security to Control for which users VBA code runs

If you want to control for which users your VBA Code runs... you can... in some situations.

VBA Code can run behind a Modified or Original Window in GP, or not at all, based on the event mode you select in the window properties in the VBA Editor:

You could modify a window mildly and place your code behind the modified version just so that you can control for which users the VBA code runs by only granting access to the modified window to certain users.  This won't work in every situation such as those in which you need to modify the window for all users but only want VBA code to run for some.

No comments: