In xl2003, from the Excel window: ToolsMacroSecurityTrusted Publishers
and then check the trust boxes at the bottom of the dialog box. Not sure if
xl2007 + has the same path.



"steve" wrote in message
...
I have a user who is learning VB in excel. When she opens the visual
basic
editor it imedietely opens and then closes. When I do it as
administrator it opens and stays open. Obviously a permission issue.


Does anyone know how to allow her to open the VB editor in Excel and
use it w/out giving her administrator access to the whole computer. I
tried giving her write permissions to the Excel.exe but this does not
solve the problem.


Thanks.