Vba Explorer. Is it possible to rename a module to correspond to the worksheet name?

[A440]

Hi
Vba Explorer. Is it possible to rename a module to correspond to the worksheet name that it contains the macros for?

[xlnitwit]

Hi,

If you mean a worksheet code module, then yes, just change its name in the Properties window (f4 if not already visible) to match- that is the default until you change the tab name.

[A440]

Many thanks, I found it in the properties box.

[A440]

Can you help with my other post?
https://www.excelforum.com/excel-pro...sheet-2-a.html