I recorded a macro (as a basis for editing, maybe with help here). But
how are you supposed to know where to find the VBA code please?

I assumed it would be in PERSONAL.xlsb as a new module, But as you see
it's replaced whatever was in Module 8, rather than creating Module 16.

https://dl.dropboxusercontent.com/u/...e-Location.jpg

What logic or inadvertent setting on my part gets it into Module 8?

Also, could I ask a few associated very basic queries please:

1. Is there any way to change 'Module 1' etc to meaningful names?
2. Or search for a macro name?
3. Is there a KB shortcut to stop a macro recording, rather than the
four clicks, in my case: Classical Menu Tools Macro Stop Recording

4. With many modules open, as I had here, can I close them all at once
instead of individually?

--
Terry, East Grinstead, UK