running sheet code with a button

**mark-ainsworth** · 04-30-2011, 11:35 AM

Hi,

I have code that currently runs automatically on selecting the worksheet it is related to.

I would like to chnage this to it running when i press a button (already inserted) into that sheet. How do i connect the two as it were?

BTW i'm running office 2007

Thanks,

Mark

**dominicb** · 04-30-2011, 11:43 AM

Good afternoon mark-ainsworth

Depends how you inserted the button.

If you used form controls, you need to take the code, and put it into a macro module, then assign that button to the macro you've created.

If you used the ActiveX controls you need to double click the button in design mode, then put the code into the window that opens.

If you're struggling with this, post back with what type of button you're using. It makes a difference.

HTH

DominicB

**mark-ainsworth** · 04-30-2011, 11:50 AM

Thanks,

I'm using the form button.

I have lots of refernces before to "Me.Range" - how do i reference this now as it isn't 'Me' anymore!

Thanks,
Mark

**dominicb** · 04-30-2011, 12:02 PM

Hi mark-ainsworth

Could you post your code.

DominicB

**mark-ainsworth** · 04-30-2011, 12:08 PM

Please Login or Register  to view this content.

**dominicb** · 04-30-2011, 12:59 PM

Hi mark-ainsworth

You won't need to specify the Me. part of the object as Excel will just assume you want to perform the instruction on the currently active sheet.

HTH

DominicB