I've recently upgraded my OS from NT4.0 to XP by reformating, installing, and
activating XP (Yes, Activating XP. . . WOW!!!)

Anyway, My Excel 97 works fine, except the VB editor screen only flashes and
never remains open. If I log in as Adminstrator this problem goes away.

The same holds true for the Word VBA editor, except it produces the
following error.

Could not open macro storage.

XP appears to be kind of "goofy" about the read/write permissions on the C:\
drive. My guess/assumption is as a limited user I don't have read/write
permission to the appropriate spot(s). My question is which "spot(s)" do I
need read/write privilages?

Thanks in advance,

Christmas May

1) Temporarily change the "limited user" account to have adminstrative rights.
2) Log on as this user with newly acquired administrative rights and launch
the VBA editor in Excel and Word. . . (This does whatever magic needs to be
done)
3) Remove the administrative rights from the user making them once again a
"limited user".


"Christmas May" wrote:

I've recently upgraded my OS from NT4.0 to XP by reformating, installing, and
activating XP (Yes, Activating XP. . . WOW!!!)

Anyway, My Excel 97 works fine, except the VB editor screen only flashes and
never remains open. If I log in as Adminstrator this problem goes away.

The same holds true for the Word VBA editor, except it produces the
following error.

Could not open macro storage.

XP appears to be kind of "goofy" about the read/write permissions on the C:\
drive. My guess/assumption is as a limited user I don't have read/write
permission to the appropriate spot(s). My question is which "spot(s)" do I
need read/write privilages?

Thanks in advance,

Christmas May