Excel 2010

[Disturbedguy]

Hey all,

Im using Excel 2010 with Macro's for the first time.

Im putting together something very basic just to hold some information. Previously in Excel I was able to create macros etc for buttons to take you to other sheet (I can still do this) however my problem is where the macros are appearing.

If I look at the Visual basic they are all appearing in Module 1, Module 2 etc which isnt what I want, I would like the macro's to appear on a per sheet basic.

So if I had a sheet called bob and a sheet called fred, any macros I setup for buttons on sheet bob as assigned to that sheet, this would make it easier to track which macro is for which sheet/ button etc.

Can anyone tell me what stupidly obvious thing I am missing?

[Disturbedguy]

Anyone?

If unclear please let me know and ill get screenshots

[maxsteel]

Sounds like you just need to rename the module 1, 2, ... etc to whatever you want to call them - or am I missing something? This you can do via the name field on the properties window.

[Disturbedguy]

Nope.

I got to the bottom of it.

Was using the wrong kind of button. All sorted now.