Hiding VBA comments ( 'asdf ) in the VBA (alt+f11) window.

[lordterrin]

I have a module that is really big, and as it's confused me quite a bit, I've made a LOT of comments as a way to remember what does what.

It's tidy, but I wonder if there is a way for me to HIDE all comments, (any line that starts with a ' ) so I can read just the code. Is there any way to do this in Excel 2007 VBA?

[Izandol]

You may try Tools - Options - Editor Format and change Comment Text setting to White foreground.

[Olly]

No. The closest you'll get within the VBE is to change the text colour of comments to match your background colour. This won't collapse / hide the rows containing only comments, but will make the comments invisible.

[lordterrin]

That works Thanks guys!