Hi, a while back my macros went away and were only visible in the VBA editor. Back then the solution for me was to log out of MS365 and relog in. Well today it happened again. Protected view and recompile did not work. What did work was opening excel then going to file > open > open and repair. It worked! I am so happy. The last time this happened I pulled all my hair out. So, for a change, I get to give back and hope if anyone else has the issue either this or the discussion here >>> MACRO'S HAVE DISAPPEARED BUT ARE STILL IN VBA will help you. Have an awesome day.