How to delete a private sub macro?

My Excel refuses to open maximized no matter what I do, so I found a macro on Microsoft.com that is supposed to fix the problem (below) but it didn't work.

Now I have 2 blank modules in my list of modules and I can't find any way to delete them. I deleted the coding from both modules but they still show up on the list. How do I get rid of them permanently?

They don't appear on my list of macros (just list of modules) - I presume it's because they are private sub macros.

Here is the macro I tried using to get it to open maximized.

Please Login or Register  to view this content.

I don't want to save it to a specific workbook though. I want it to work every time I open Excel, and when I open Excel, it automatically opens PERSONAL.XLSB.

Is the reason why Excel will not open maximized related to the fact that I have Macros saved under PERSONAL.XLSB?

Thanks guys, I'll give it a try.

I seem to be having some trouble here. How do I put it into the ThisWorkbook module?

Brilliant! Thanks everyone for sticking with me on this - seems to be working fine now.

I started having a problem today with excel opening multiple instances of excel and i think i traced it back to this problem from years ago. I too added in a private sub in my personal.xlsb workbook. This was not done as a module, but rather an event (that the right name?) where the VBA dropdowns list it as Workbook and Open. How do I get rid of this now? I delete the code and it just comes back...