Macros not displayed in "View Macros Box" Alt F8 Hoping someone can help.

[jgoomster]

I haven't lost my Macros. I can open up VBA alt F11, and find and run any of my macros, but when i open up the view macros window (displayed in my screenshot) it is blank. I am able to toggle through the "macros in" dropdown box but it doesn't seem to make a difference. I have been googling this problem and it doesn't seem common, but it is frustrating for me.

I have rebooted; I have also tried repairing office 365 to see if that would solve the problem.

I am not sure what I have done. I am good with excel but pretty novice with VBA.

Any help would be appreciated.

Thanks,

 

[Fluff]

Hi & welcome to MrExcel.
Do you have Option Private Module at the top of your modules?
Also do any of your macros start Private Sub

 

[jgoomster]

I do not. here is a snippet of Alt+f11, this is stored in my personal macro book and I can run it on that file, but the window is still showing no macros. It is the weirdest thing.

 

[Fluff]

In that case I'm afraid I have no idea. It's not something I've ever come across.

 

[RoryA]

Is the IsAddin property of your personal macro workbook set to True?

 

[jgoomster]

i am sorry, i dont know how to check. i didnt change any settings.

 

[jgoomster]

i am sorry, i dont know how to check. i didnt change any settings.

ignore the screen shot please on this post, new to the forum as well. my bad

 

[RoryA]

Double click the ThisWorkbook object for the personal macro workbook in the project explorer window (usually top left in the vb editor) then press f4 if the properties window isn't already visible. You should then be able to see the IsAddin property.

 

[jgoomster]

Double click the ThisWorkbook object for the personal macro workbook in the project explorer window (usually top left in the vb editor) then press f4 if the properties window isn't already visible. You should then be able to see the IsAddin property.

Thank you, it is false, should i change it to true?

 

[RoryA]

I thought you were talking about your Personal macro workbook?