Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a customized icon for specific filename within toolb
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a customized icon for specific filename within toolb
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a customized icon for specific filename within t
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a customized icon for specific filename within t
Depends upon which version of Excel you are using.
In 2003 or earlier go to ToolsMacroRecord new macro. FileOpen and open the file you want. Stop recording. Example code from the recording looks like this.............. Sub Macro6() ' Macro6 Macro ' Macro recorded 8/4/2009 by Gord Dibben Workbooks.Open Filename:= _ "C:\Program Files\Microsoft Office\Exceldata\12months.xls" End Sub Gord On Tue, 4 Aug 2009 07:41:01 -0700, Eric wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create a customized icon for specific filename within t
Thank you very much for your suggestions
Could you please tell me how to assign the following code into the button without opening any spreadsheet? Do you have any suggestions? Sub Macro1() Workbooks.Open Filename:="E:\folder\filename.xls", UpdateLinks:=3 End Sub Thank you very much for any suggestions Eric "Gord Dibben" wrote: Depends upon which version of Excel you are using. In 2003 or earlier go to ToolsMacroRecord new macro. FileOpen and open the file you want. Stop recording. Example code from the recording looks like this.............. Sub Macro6() ' Macro6 Macro ' Macro recorded 8/4/2009 by Gord Dibben Workbooks.Open Filename:= _ "C:\Program Files\Microsoft Office\Exceldata\12months.xls" End Sub Gord On Tue, 4 Aug 2009 07:41:01 -0700, Eric wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a customized toolbar button? Excell 2007 | Excel Discussion (Misc queries) | |||
How do I insert the filename to a specific cell of the worksheet? | Excel Discussion (Misc queries) | |||
How can I create customized help or instructions? | Excel Discussion (Misc queries) | |||
Transferring customized icon bars in excel and word to new computer | Setting up and Configuration of Excel | |||
How do I create a customized template? | Excel Discussion (Misc queries) |