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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If it shows you a reference to the macro instead of the macro itself, keep pressing Find Next until you see it.
ASKER
Thanks Martin. I will attempt this tomorrow. Users are gone for the day.
Try it yourself. Can you find it? If so what does the declaration look like?
ASKER
I don't have access to the file. It's Healthcare. We have to wait for the users to return.
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.
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.
ASKER
Thank you. I did check those setting are all ok.
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
ASKER
Thanks for the assist guys. The user is ok now.
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
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
BTW, thank you for my 8 millionth point!
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?