Modifying VBA code in MS Excel 2010

[Lou_Reed]

Okay, I forgot how to do this. I want to see the VBA code behind a button on an Excel spreadsheet that I am working on. How do I do that?
I also anticipate making some changes in the VBA code. So after that how do I compile the code in Excel to accept the changes?

Any help appreciated.

Thanks in advance.

Respectfully,

Lou Reed

[June7]

1. Make sure Developer tab is available

2. Open the Excel VBA editor

3. Go to the procedure

4. Edit code

5. Debug > Compile

6. Save workbook

If you need to edit the button itself (name, size, move, caption, etc):

1. make sure worksheet is not protected

2. click 'Design Mode' on the ribbon

3. select button and edit properties (right click on the button is one way to open Properties box)