We help IT Professionals succeed at work.

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.
Comment
Watch Question

Commented:

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 PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
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.
Social distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Go to Visual Basic via Alt+F11, type Ctrl+F and fill out the search parameters like this where MACRO is the full name of your macro and press Return.
2020-02-20_13-12-21.png
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
If it shows you a reference to the macro instead of the macro itself, keep pressing Find Next until you see it.
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
Thanks Martin. I will attempt this tomorrow. Users are gone for the day.
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Try it yourself. Can you find it? If so what does the declaration look like?
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
I don't have access to the file. It's Healthcare. We have to wait for the users to return.
CERTIFIED EXPERT

Commented:
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 PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
Thank you. I did check those setting are all ok.
CERTIFIED EXPERT

Commented:
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
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Author

Commented:
Thanks for the assist guys. The user is ok now.
Martin LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
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 LissSocial distance - Don't touch your face - Wash your hands for 20 seconds
CERTIFIED EXPERT
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
BTW, thank you for my 8 millionth point!