When you start a function for example: =
you can select a different file using Window on the menu bar or the file
icon on the task bar to select a cell in a different file. My question is ;
is there a way to start the function for example with: = .... and then click
a command button on the sheet where the code on the attched macro is to:
Windows("ExcelFile").Activate and have it go to the window of the "ExcelFile"
and then select the cell you want to reference and hit -Enter- and have it
function properly. When I start with = it will basically lock the
CommandButton on the sheet and therefore the macro does not run. Is there a
way to make this work?

Thank you,

Steven