Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I keep a macro with spreadsheet when moved
I am trying to keep a macro with a workbook when I move it from my laptop to
my desk computer. I have to redirect the macro everytime I move the workbook |
#2
|
|||
|
|||
It sounds like you're assigning the macro to a button/object/icon on a toolbar.
If that's the case, you may want to reassign the macro in code to the workbook that owns the macro. If you used a button from the Forms toolbar, a simple change may work for you. Delete that button and use a commandbutton from the control toolbox toolbar. Then double click on that commandbutton and have that code call your macro: Option Explicit Private Sub CommandButton1_Click() Call myExistingMacro End Sub If you have trouble, you may want to post back with more details. SpeclAngel wrote: I am trying to keep a macro with a workbook when I move it from my laptop to my desk computer. I have to redirect the macro everytime I move the workbook -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro not found when spreadsheet viewed in Internet Explorer? | Excel Discussion (Misc queries) | |||
Spreadsheet print including macro buttons? | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Run a macro when opening a spreadsheet | Excel Discussion (Misc queries) | |||
Sample spreadsheet of using macro | Excel Worksheet Functions |