Visual Basic Editor Opening and Closing for User
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.
"Dave Peterson" wrote in message
...
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
|