VB Code to assign Macro Button to certain Code

Hello:

Please refer to attached file.
I have created Button to Press.
I need VB code so that when i press the Button, it will run the VB Code which is Cell G2.
In this case it needs to run Sub Clear in Personal.XLSB
Let me know if you have any questions.
Thanks.

Riz

Hi,

not sure if I understood well.

Try following..

This to Personal.xlsb and its module:

Sub Clear()
With ActiveSheet
.Range("G2").Interior.ColorIndex = 3
End With
End Sub

And this to MacroButtons.xls module:

Sub Button1_Click()
Run ActiveSheet.Range("G2").Value
End Sub

Is this what you want?

Regards,
sysss