Avatar of Edward Pamias
Edward Pamias
Flag for United States of America asked on

Where can I find a Excel 2016 MACRO?

I have a weird problem. 4 users access the same file on a shared drive, only 2 of the 4 have the MACRO listed under Macros in the same file. How can I find where this macro is located.
Microsoft OfficeVBAMicrosoft Excel

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Geekamo

Is the macro stored as a personal macro (for the two that DO have access)?


Do the other two users have the Developer tab visible?

Edward Pamias

ASKER
I enabled the Developer tab on all machines. They all work off the same file so I am wondering how 2 can have the MACRO the others don't. No Personal macro enabled on the ones that are working.
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

If it shows you a reference to the macro instead of the macro itself, keep pressing Find Next until you see it.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Edward Pamias

ASKER
Thanks Martin. I will attempt this tomorrow. Users are gone for the day.
Martin Liss

Try it yourself. Can you find it? If so what does the declaration look like?
Edward Pamias

ASKER
I don't have access to the file. It's Healthcare. We have to wait for the users to return.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Arana (G.P.)

it may be an excel setting, open excel,
options/trust center/trust center settings, go to the MACRO SETTINGS
see if macros are disabled, you have some options like, disable aall macros, disable all macros with notification, enable all, etc, also depending how your users are opening the file (web or local or share) document may open in protected view mode, check protected view also under trust center settings.

 
if your macros are inside the document that should solve it, if your macro is in a separate template file, and maybe even over the network, you would have to check permissions for each of the users that cannot load them.
Edward Pamias

ASKER
Thank you. I did check those setting are all ok.
Arana (G.P.)

Can you try opening your file using a WORKING users credentials in a NON working users PC?, this would discard any permissions problem and will isolate the problem to a local excel configuration or local or user policy
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Edward Pamias

ASKER
Thanks for the assist guys. The user is ok now.
Martin Liss

You’re welcome and I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2019
              Experts Exchange Top Expert VBA 2018, 2019
              Experts Exchange Distinguished Expert in Excel 2018
Martin Liss

BTW, thank you for my 8 millionth point!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.