Multiple Modules?

[handysmurf]

I have like 15 Modules in my workbook, I have no idea why 14 of them are there. I don't know that much about VBA so I don't know if they are needed. I do have a bunch of buttons connected to macros. Is this a glitch?

 

[Domenic]

First, go to your Visual Basic Editor (Alt+F11). Then, make sure that the Project Explorer (Ctrl+R) is visible. Then, for each module that you see for your VBAProject/Workbook, right-click the module, and select View Code. If there's nothing there within the code module or if there's only the line Option Explicit, you can simply delete it by right-clicking the module, and selecting Remove Module.

 

[handysmurf]

Done. Thanks, I'm not sure if it makes any difference. Excel or this worksheet is sluggish and I happened to notice that, not sure if that will make any difference.

 

[Domenic]

You're very welcome!

Cheers!

 

[Michael M]

@handysmurf
If you press CTRL + End...which cell do you go to ???
Do you have lots of charts, pivots, formulas in the sheet ??