Hi Need little help " Cannot run the Macro. The Macro may not be available on this workbook or"

[zone709]

Hi,
We updated excel from 2007 to 2016. I added all the ribbon short cuts to all macros. The Personal macros work no problem. I built though a macro on a worksheet which is in its own Module not personal awhile ago but I keep getting this pop up. " Cannot run the Macro. The Macro may not be available on this workbook or" I remember getting it years ago and i fixed it but i cant remember how. I went into settings at Trust and made sure things are enabled and things are not. I went back to my old computer where this workbook works and no issues. and have same settings on. Does anyone know what i am missing that i keep getting this pop from? Thank

 

[Micron]

Using the problem pc, is the macro name visible in the macros list? You're sure that Trust settings are correct for the updated pc?

I went into settings at Trust and made sure things are enabled and things are not

Not sure what that means, but I read it as "I looked at Trust settings and the folder that contains my file is not listed there". It has to be there.

 

[zone709]

Hi i figured it out. The workbook was under the server ip. Which tells excel its not safe. I copied and paste it to desktop and works fine now. Since if you right click the file to try to unblock it. It doesn't have the option. I tried to add the ip address to the trusted box under internet options but still is not working that way. Will try tomorrow.