Visual Basic Editor Opening and Closing for User

[steve]

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.

 

[JLGWhiz]

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

 

[steve]

Thank you that is helpfull.

Unfortunetely this is Excel 97. It doesnt have this feature. Any other
thoughts.

 

[JLGWhiz]

Can't remember that far back. Twenty four hours is my limit.

 

[steve]

Understood.

Anyone else want to make a stab at it.

 

[Clyde]

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.

 

[Dave Peterson]

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???)

 

[JLGWhiz]

I could not find anything on the MS Support site that describes such a
condition, although I did find a couple of articles about the changes
included in xl97 from earlier versions. That was the first version with the
VBE code modules vs code sheets. But it made no mention of any special
activation procedure like xl2003 or later. I believe you are correct about
having to load the option during installation, but that was the year that I
was on medical leave and my workstation was up and running when I returned,
so I really don't remember a lot about the transition. Besides, if the
administrator can open it, the user should be able to.

 

[steve]

The way she accesses it is by opening excel, going to macros and then
clicking on VB Editor menu. (I have not tried the quick keys but I
asume its the same)

The thing is, is that VBE IS INSTALLED, that is, when I open it on
her machine after logging in as network administrator It works fine.
Sooo that tells me that it IS installed (I asume).

The other thing that seems strange is that the problem is not per say
that the program doesnt open, what actually happens is that after you
click to open it it opens for a split second (you almost cant see it
open) but you can see that it is the VBE but then closes imedetely. I
dont get an error like "permission denied" or something. It just opens
and closes.

Does that provide enough info describing the issue??
thanks.

 

[Dave Peterson]

Depending on how the admin set up permissions, I would expect that there are
lots of things that the admin can do that the users can't.

The thing that surprises me is that the VBE opens and then closes. That doesn't
seem to fit anything. If it was not installed, I would expect that the VBE
would not even open.

 

[Dave Peterson]

It provides more info, but it doesn't help me.

Have you tried reinstalling?

You may want to try:
OFF97: How to Completely Remove Microsoft Office 97
http://support.microsoft.com/default.aspx?scid=kb;EN-US;158658

 

[steve]

Yes well the opening and closing thing, I agree seems odd. Its like
something is closing it like a AV program. But Im fairly certain thats
not it. I have not tried to reinstall, believing perhaps foolishly
that, that will not change anything??

I can tell you that I have fixed it (I think) by doing the following.
I made the user a "Power User" on that local machine. Again showing
that it is obviously some sort of permission issue. Of course anyone
else who wants to put their 2 cents in Im happy to oblige, if you want
to make a stabby motion at it. Anyway, the power user option is one
way of resolving it I suppose.

Thanks.

 

[Dave Peterson]

It sounds to me like it's not an excel problem. It sounds to me like it's a
windows permission problem.

You may want to post to a windows group and include the version of windows that
you're using.

ps. Did you try that KB article?

 

[steve]

Yes perhaps going to a Windows XP group might work. I recognize that
people who do VBE programing generally have more access to their
computers (permissions) I was hopeing that a VB users group would have
come up against the problem. However I know this is an old version,
and as I say most developers have full access certainly at least to
their own computer. So I can see why others may not have had the
problem.

I have not tried the link to remove it all, partially because I solved
it, if I had not that might have been the next step. However as
mentioned, it works fine for the Administrator so I was under the
beleif that a reinstall would likely put it back the way it was.
Working perfectly for the Admin but not for the user. Admittedly that
is not always the case and perhaps permissions got screwed up somehow.
One never knows untill one tries.

Thanks.

 

[Dave Peterson]

And that KB article shows how to remove all remnants of xl97. That's different
from using the control panel to add/remove programs.