Thank you very much for suggestions
Could you please give me any suggestions on how to place the coding into
macro? so I can select the macro from the list.
Thank you very much for any suggestions
Eric

"Jacob Skaria" wrote:

Click on the button. The macro list will populate..Select the macro from the
list.

If this post helps click Yes
---------------
Jacob Skaria


"Eric" wrote:

Does anyone have any suggestions?

Customize your Toolbar by placing a button on it and assign the following
macro to
that button.

ToolsCustomizeCommandsMacros.

Drag smiley face to your Toolbar.


The given Micro coding
Sub Macro1()
Workbooks.Open Filename:="E:\folder\filename.xls", UpdateLinks:=3
End Sub

Does anyone have any suggestions on how to assign the following code into
the button?

Thanks in advance for any suggestions
Eric