Thank you very much for suggestions
Could you please tell me how to create the macro to open specific file?
Thank you very much for any suggestions
Eric

"Gord Dibben" wrote:

Turn on the macro recorder to get the code for opening a specific
workbook/file.

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

ToolsCustomizeCommandsMacros.

Drag smiley face to your Toolbar. Right-click on smiley and "assign macro"

You can also change smiley to different Icon by right-click and "change
button image"


Gord Dibben MS Excel MVP

On Tue, 4 Aug 2009 03:06:10 -0700, Eric
wrote:

Does anyone have any suggestions on how to create a customized icon for
specific filename within toolbar?
Within excel, there are many toolbar under the pull down menu, I would like
to add an icon within toolbar, which refer to specific filename, so whenever
user opens excel, he can click on this icon to open specific file without
going through browing the file under different directory.
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric