View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to assign macro coding into customized button?

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