| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Editor Opening and Closing for User
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
Thank you that is helpfull.
Unfortunetely this is Excel 97. It doesnt have this feature. Any other thoughts. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
Can't remember that far back. Twenty four hours is my limit.
"steve" wrote in message ... Thank you that is helpfull. Unfortunetely this is Excel 97. It doesnt have this feature. Any other thoughts. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
Understood.
Anyone else want to make a stab at it. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
"steve" wrote in message ... Understood. Anyone else want to make a stab at it. OJ Simpson would probably want to take a stab at it but he doesn't frequent this NG. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Editor Opening and Closing for User
I've never seen this happen, but maybe you can explain how she's trying to
access the VBE. Is it through alt-F11 or tools|macro|... Does it make a difference? And a wild guess... Are you sure you installed the VBA component for her? I'm not sure if xl97 had this as an option (I think it did) that you choose to install, run from disk, install on first use (or something like those). Have you tried reinstalling excel completely? (And including that VBA option???) steve wrote: Understood. Anyone else want to make a stab at it. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opening Visual Basic Editor | Excel Discussion (Misc queries) | |||
| Visual Basic Editor | Excel Discussion (Misc queries) | |||
| Excel default module when opening visual basic editor | Excel Programming | |||
| Visual basic editor | Excel Discussion (Misc queries) | |||
| Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
Hybrid Mode
