VBA - Run-time error '91' - Object variable or With block variable not set

[MrPartial]

Hi all! Having an issue with the following error. I receive this error every single time I open excel. I also receive this error while attempting to use my hyperion essbase add-in. It originally started while simply creating a macro / button to do a simple retrieve data function within hyperion.

Now I can't get rid of this error. I've tried the majority of suggestions I could find on google, and nothing!

I removed all my macros, so I don't have any macros that can be executed, unless there is something I can't see. I'm still quite basic on the VBA / Macro side of excel, so any simple explanations would be extremely helpful.


Capture.JPG

You can also see that I don't have anything in my Macros at the moment that should be causing this error, that is why i'm confused.

Cap2.JPG

Capture3.JPG

Thanks guys!

[gmr4evr1]

2 of the 1st 3 listed in the project window have code in them, I know because I use those 2. I'm not sure what the top one is as it is PW protected. The 3rd one, VBAProject(FUNCRES.XLAM) is probably code for a Ribbon Button.
So, there is still some code in there in places. Double click each sheet, workbook, module etc. to be sure there is no left-over code.

[MrPartial]

i deleted my personal macro workbook in XLSTART folder and it fixed the problem. Thanks all