asked on

Excel Start Up Macro

Hi, was hoping someone could give me some troubleshooting ideas on an issue I am having for a user with an excel start Macro.

For the user, when she logos on and opens Excel, it doesn't load/show up as an ADD-IN or as available.
When I or anyone else logs on, it loads and works fine.

I have tried a office repair, but don't think its the install, seems to have something to do with her profile, but it doesn't make sense to have to give her a whole new profile for such a small thing. Just need to have some idea of what could be the prblem
Scan0001.pdf

[ fanpages ]

For clarity:
Are you referring to a Workbook_Open() or Auto_Open() event in a workbook that is opened manually by the user, or to a workbook that resides at the Startup location shown in your attached ".pdf" (L:\offadmin\altstart) & that you are expecting to be opened automatically when an MS-Excel application session is launched?

If the former, what code statements are within either (or both) of those two events?
If the latter, does the user have sufficient network privileges to open files in that location?

Additionally, what is shown within your user's "Macro Settings" of the "Trust Center"?

GST-GRIDTECH

ASKER

Hi, Thank you for responding.

Startup location shown (L:\offadmin\altstart)

user does have the privileges.

It seems to be something on the local machine specific to her profile.
If she goes to another PC, it works .

if I or anyone else logs onto her PC it works, like it works for EVERYONE in the company All 300.
but not fer her on her assigned PC.

I did compare her "Macro Settings" of the "Trust Center" and they MATCH what everyone else has,
but I don't recall what it is right now..but i did compare her setting to everyone's and they match..

SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GST-GRIDTECH

ASKER

Hi,

its a file within the Startup file location.
if the user logs on to another PC. No issue.

If I or Anyone logs onto her PC, not issue.
it is ONLY when she logs ONTO that PC and I would hate
to have to give her a new profile, just because of this
Excel issue. there has to be some way to correct the issue..

GST-GRIDTECH

ASKER

its a file within the Startup file location., everyone has this file for excel., in the same startup location and the location is in everyones trusted file location.

SOLUTION

[ fanpages ]

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

GST-GRIDTECH

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GST-GRIDTECH

ASKER

turns out, this was a systems admin error, that could only be corrected, by the Admin at the site.
i dint have the privileges to correct,,,