Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign macro coding into customized button?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign macro coding into customized button?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign macro coding into customized button?
Hi Eric
--Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From VBE menu 'Insert' a module and paste your macro in the code pane. --Get back to Workbook. --You can either run macro from Tools|Macro|Run <selected macro() or click on the toolbar button and assign the macro.. If this post helps click Yes --------------- Jacob Skaria "Eric" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to assign macro coding into customized button?
Thank you very much for suggestions
I have inserted the macro code into button, but when I move the workbook file into different directory, the button cannot run the missing macro from this workbook, could you please give me any suggestions on how to edit the path on linking to macro coding for button? Thank you very much for any suggestions Eric "Jacob Skaria" wrote: Hi Eric --Set the Security level to low/medium in (Tools|Macro|Security). --From workbook launch VBE using short-key Alt+F11. --From VBE menu 'Insert' a module and paste your macro in the code pane. --Get back to Workbook. --You can either run macro from Tools|Macro|Run <selected macro() or click on the toolbar button and assign the macro.. If this post helps click Yes --------------- Jacob Skaria "Eric" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a customized button with macro in Excel 2007 for acce | Setting up and Configuration of Excel | |||
Assign a macro to a button | Excel Discussion (Misc queries) | |||
Customized Macro Button Check | Excel Discussion (Misc queries) | |||
Assign a macro to a command button | Excel Discussion (Misc queries) | |||
How do I Assign Macro to a button? | Charts and Charting in Excel |