viewing the code and identifying the sub routine

[Kencosgrove]

Hi

I am a VBA novice and have been given an excel workbook with a front end that has a lot of buttons that have VBa behind them. I want to edit something minor for one of the buttons but I need to firstly know what to edit -

Once I view the code, how would I go about identifying which Sub routine that particular button relates to within the code module? The sub names dont give it away and there are no comments in the code

Thanks in advance !

[Mumps1]

Right click the button and then click on 'Assign Macro'. The associated macro will appear in the box at the top.

[Kencosgrove]

Hi, It seems the be the case for some of the buttons, but not the ones I want to edit! they seem to have different hyperlinks there that are nowhere to be found in the code

thanks for the quick response